4 ms·
Looks like we are using sqlite and Python 3.5.3, synapse cache factor is currently not set in our config, any pointers for how to migrate to Postgres? This box
by StudentStuff 7y ago
Looks like we are using sqlite and Python 3.5.3, synapse cache factor is currently not set in our config, any pointers for how to migrate to Postgres? This box has basically been given to me after the person who set it up gave up in frustration.
- Arathorn 7y agohttps://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 7y 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 7y 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.