add MATERIALIZED keyword to ring-fence some CTEs (i.e. WITH blocks)

[DLN] add MATERIALIZED keyword to some CTEs (WITH blocks) to ring-fencing behavior of postgres 10 for those CTEs. Disable jit compiling of queries for entire hivemind datbase because it mostly hurts performance of hivemind queries which typically don't have long execution times but are complex queries that take a long time to compile

.gitlab-ci.yaml

@@ -23,7 +23,7 @@ stages:
   # Setup runner environment (to connect to correct postgres server, mainly).
   - TMP_VAR=$(cat hive-sync-runner-id.txt 2>/dev/null || true); export HIVE_SYNC_RUNNER_ID=${TMP_VAR:-0}
   - eval $(cat "$RUNNER_CONF" | ./scripts/ci/setup_env.py --current-runner-id=${CI_RUNNER_ID} --hive-sync-runner-id=${HIVE_SYNC_RUNNER_ID})
-  - export RUNNER_POSTGRES_PORT=172.17.0.1
+  - export RUNNER_POSTGRES_HOST=172.17.0.1
   - export RUNNER_POSTGRES_PORT=25432
   - echo "Postgres host $RUNNER_POSTGRES_HOST port $RUNNER_POSTGRES_PORT"