element-hq / element-hq/synapse
Have background updates that create indices report their progress
Open
A-Database
O-Uncommon
S-Tolerable
T-Enhancement
- Dominant language
- Python
- Stars
- 4.6k
- Forks
- 600
- Avg merge
- 5d 22h
- Merged PRs (30d)
- 51
Description
This issue has been migrated from [#15087](https://github.com/matrix-org/synapse/issues/15087).
---
Postgres 12 introduces a way for connections to interrogate the status of a `CREATE INDEX` in progress, see https://www.postgresql.org/docs/12/progress-reporting.html
It would be great to have background index creation periodically query this data and store it in the background_updates table, so we have a way to get some feedback on how index creation is going.
Contributor guide
Assessment
This issue has not been assessed yet.