Defined base CI docker image, to be used as a base for actual CI container.

See merge request !530

vops container received from Vops provider must be stripped from wrapping...

See merge request !527

vops container received from Vops provider must be stripped from wrapping block number structure to avoid failure at further processing.

Fixed syntax errors causing an upgrade procedure to fail.

See merge request !525

Optimized update_notification_cache procedure:

See merge request !523

- simplified hive_accounts_rank_view
- added dedicated index to enrce IndexOnlyScan execution plan during query.

Upgraded min. setuptools version.

See merge request !521

Eliminated need to use edit installation mode during executing a pip tool. This fixes problem appeared lately when pip tool has been upgraded up to version >= 21.0 where edit install mode support has been dropped.
Also improved detecting of old setup tools - now too old setuptools should result in installation error.
SQL scripts are added now as package resources (instead of other datafiles) what is preferred way to distribute other data files.

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

See merge request !516

- update_posts_rshares does not contain anymore JIT disabling code
= db_upgrade procedure contains a code to disable JIT at database level.

Latest schema changes incorporated into upgrade scripts.

See merge request !515

[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

Conditionally disabled JIT optimizer during execution of update_posts_rshares

See merge request !513

Conditionally disabled JIT optimizer during execution of update_posts_rshares to eliminate LIVE SYNC slowdown. Related to issue #168

VACUUM ANALYZE must be executed after index creation but before other...

See merge request !512

VACUUM ANALYZE must be executed after index creation but before other after-initial-sync actions (to update execution plans)