3 ms·
https://github.com/matrix-org/synapse/blob/master/docs/postgres.rst https://github.com/matrix-org/synapse/blob/master/docs/postg... has the details. Fwiw, we'r
by Arathorn 8y ago
https://github.com/matrix-org/synapse/blob/master/docs/postgres.rst https://github.com/matrix-org/synapse/blob/master/docs/postg... has the details.
Fwiw, we're addressing the sqlite issue by stopping servers from federating for now if they are on sqlite (https://github.com/matrix-org/synapse/pull/5078 https://github.com/matrix-org/synapse/pull/5078). Sorry you got bitten by this.
- StudentStuff 8y agoIt happens, guessing SQLite was default at one point or suggested by the install guide that was followed. Kinda surprised it has survived thus far, never really thought of SQLite as something for high volume, multi-user messaging. Gonna go try the migration guide here :P
- krferriter 8y agoSQLite is definitely not ideal for high volume and high transaction frequency. Postgres will be better at that. I have used it for quickly getting a single table database up that I can just dump into and then query through linearly afterwards. It is better than dumping to JSON or some other purely textual serialization.