Skip to content

Blocksearch rewrite pg17

Michal Zander requested to merge mzander/rewrite-blocksearch-pg17-3 into develop

Queries that doesn't use key-value structure's could finally can use proper indexes while searching and aggregating blocks (thanks to postgresql 17 changes to btree indexes)

blocksearch indexes GIN -> btree:

  1. faster creation,
  2. can be created concurrently,
  3. query can sort without BITMAP AND to block_num index which results in much better performance in most cases

contains also:

  1. fixes for incomplete permissions for hafah_backend (hafah's MR 171),
  2. fixes for rewrite rules (haf's MR 566),
  3. fixes for healthchecker issue (reptracker issue reputation_tracker#9 )
  4. removal deprecated directory gui !251 (8d7ec800)
  5. added missing pattern tests for path-filter parameter in get_block_by_op api !251 (c3e6df4d)

Requires:

  1. haf!566 (merged)
  2. HAfAH!171 (merged)
Edited by Michal Zander

Merge request reports

Loading