element-hq / element-hq/synapse
very slow inserts into event_search
Open
A-Message-Search
A-Performance
A-Search
O-Uncommon
S-Major
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 [#4219](https://github.com/matrix-org/synapse/issues/4219).
---
we frequently see inserts into the event_search table taking 30 seconds or more. IIRC the insert is done synchronously when a user sends an event so this must give a terrible UX. We should find out why it is so slow (do we need to fiddle with the postgres settings again?
Contributor guide
Assessment
This issue has not been assessed yet.