Skip to content

Create a "manually" maintained materialized view for node metadata

Philipp Kern requested to merge pkern/snapshot:db-fixes into master

It's necessary to materialize node_with_ts to speed up queries massively, but materialized views of this size (6 GB+) come with a hefty penalty for the WAL - which hurts in both synchronization and backup space. Instead add a manually maintained table that is updated whenever a node is touched. This will still generate a lot of churn by design (after all, it will be executed for every node that is still alive at the current import time), but much less than regenerating the whole view.

Merge request reports

Loading