This repository was archived by the owner on Apr 26, 2024. It is now read-only.
This repository was archived by the owner on Apr 26, 2024. It is now read-only.
Manually set n_distinct for event_search.room_id to avoid bad Postgres query plans #14402
Description
On matrix.org we discovered that every now and again event_search queries would take forever due to using the wrong query plan. This was due to Postgres underestimating the number of room IDs that existed.
To fix this we should add a schema update with:
ALTER TABLE event_search ALTER COLUMN room_id SET (n_distinct = -0.01);like we do for state_groups_state.state_group already.