Skip to content

update_notification_cache performance improvement (during live-sync execution)

Bartek Wrona requested to merge bw_notifications_view_performance_fix into develop-haf

hive.hivemind_app_blocks_view data are provided by simple subquery instead of JOIN, since at least PostgreSQL 12 planner misbehaves and uses table scan instead of index scan to select row(s) from hive.blocks table, what kills performance.

Merge request reports