GitLab

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)

Post active property is not updated anymore. Also it is removed from API responses.

See merge request !511

Post active property is not updated anymore (so it is temporary left value assigned at post data creation time)

Performance optimization of `update_posts_rshares` procedure.

See merge request !510

Improved storage management during massive reputation data processing

See merge request !509

- Eliminated call to `ANALYZE` statement after creating indexes, since it does not give any positive effects
- Massive account reputations processing moved before index/other tables suplement to make possible storage reclaim (after eliminating reputation data)

truncate_account_reputation_data optionally uses (at massive After Initial Sync phase) TRUNCATE statement to remove old reputation data records, to automatically reclaim database space without a need to explicitly call VACUUM FULL.

Improvements of After Initial Sync phase

See merge request !507

restore CTRL+C functionality ans sync from sql with mock

See merge request !508

update_all_hive_posts_children_count removes all temporary data stored inside __post_children to reclaim space.

Eliminated call to VACUUM ANALYZE hive_posts during After-Initial-Sync phase, since there is no performance benefits related to this action (and it consumes significant amount of time).

Removed temporary creation of index hive_votes_post_id_rshares_vote_is_effective_idx (replaced with permanent one covering also block_num) to speedup update_posts_rshares at FAST_SYNC (phase between massive sync and live-sync)

jsonrpcserver package version changed to 4.2.0 (available at pypi repository) to avoid setup problems caused by old pip tool version

See merge request !506

jsonrpcserver package version changed to 4.2.0 (available at pypi repository) to avoid setup problems related to referencing git commit (it was bad handled by pip version older than 18).

Various maintenance tasks

See merge request !504

Added default parameter to the Db contructor to avoid errors when hive sync is...

See merge request !505

Added default parameter to the Db contructor to avoid errors when hive sync is supplied by block_log database.
Fixed VACUUM ANALYZE calls to improve compatibility to Postgres 12.