element-hq / element-hq/synapse

Split event_json storage into separate DB

Open
#4,892 0 comments 0 reactions 0 assignees View on GitHub
A-Performance 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 [#4892](https://github.com/matrix-org/synapse/issues/4892).

---

It would be good to support having the `event_json` table in a separate DB, as its quite a large table. This should be the easiest of the large tables to allow being split up, as its an append only table, and we already special case fetching from it.

It would also be nice to support sharding here, to stop us from being constrained by any limits to the sizes of a single DB.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.