element-hq / element-hq/synapse
The `cache_invalidation_stream_by_instance` table is filled even when workers are not in use
Open
A-Database
A-Disk-Space
S-Minor
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 [#15869](https://github.com/matrix-org/synapse/issues/15869).
---
The only precondition to having this table filled with cache invalidations is that the database engine is Postgres.
If we were interested, we could cut this down so this table is not populated when you're not using workers. (I'm not sure if we have such a flag available to be honest, but we can consider it if this is important to us!)
The benefit would be a small reduction in database I/O and CPU use for Postgres monoliths.
Related: #15868 which cleans up old rows in this table.
Contributor guide
Assessment
This issue has not been assessed yet.