Commit message (Collapse) | Author | Age | Files | Lines | |
---|---|---|---|---|---|
* | Reduce likelihood of Postgres table scanning `state_groups_state`. (#10359) | Erik Johnston | 2021-07-15 | 1 | -0/+34 |
| | | | | | | | | The postgres statistics collector sometimes massively underestimates the number of distinct state groups are in the `state_groups_state`, which can cause postgres to use table scans for queries for multiple state groups. We fix this by manually setting `n_distinct` on the column. | ||||
* | Reorganise the database schema directories (#9932) | Richard van der Hoff | 2021-05-07 | 10 | -0/+233 |
The hope here is that by moving all the schema files into synapse/storage/schema, it gets a bit easier for newcomers to navigate. It certainly got easier for me to write a helpful README. There's more to do on that front, but I'll follow up with other PRs for that. |