Skip to content
Snippets Groups Projects
  • Erik Johnston's avatar
    28ac1a1a
    Speed up deleting of old rows in `event_push_actions` (#15531) · 28ac1a1a
    Erik Johnston authored
    Enforce that we use index scans (rather than seq scans), which we also do for state queries. The reason to enforce this is that we can't correctly get PostgreSQL to understand the distribution of `stream_ordering` depends on `highlight`, and so it always defaults (on matrix.org) to sequential scans. 
    28ac1a1a
    History
    Speed up deleting of old rows in `event_push_actions` (#15531)
    Erik Johnston authored
    Enforce that we use index scans (rather than seq scans), which we also do for state queries. The reason to enforce this is that we can't correctly get PostgreSQL to understand the distribution of `stream_ordering` depends on `highlight`, and so it always defaults (on matrix.org) to sequential scans.