Files
Kabiru Mwenja f94d7b0bfc Resolve the changes-filter predecessor once in a journals CTE
The :only_changes filter re-seeked each journal's predecessor in every EXISTS
branch (~7 LATERAL lookups per row). A CTE now shadows the journals table,
exposing predecessor_id/predecessor_data_id once per row, and each branch reads
those columns instead. On a 703-journal work package this cuts the COUNT from
~1.13M to ~35K shared buffers.
2026-06-09 10:25:21 +03:00
..
2025-12-15 15:58:14 +02:00
2025-10-14 12:01:58 +02:00
2025-11-12 16:02:52 +01:00
2026-03-06 13:29:07 +01:00
2026-06-04 09:05:50 +02:00
2026-01-26 13:22:44 +01:00