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

scripts/ci/setup_env.py

@@ -96,6 +96,11 @@ def setup_env(current_runner_id, hive_sync_runner_id, infile, outfile, end, **kw
                     runner[key] = value
 
     for key in runner:
+        if key == 'postgres_host': # to be eliminated when CI will be only at psql12
+            runner[key] = 'localhost'
+        if key == 'postgres_port': # to be eliminated when CI will be only at psql12
+            runner[key] = 25432
+
         output(
             f'export RUNNER_{key.upper()}="{str(runner[key])}"',
             outfile,