3 ms·
Postgres also does not synchronously replicate for free. You can setup both to get a confirmation write if you require that durability.
by 0cf8612b2e1e 5mo ago
Postgres also does not synchronously replicate for free. You can setup both to get a confirmation write if you require that durability.
- orf 5mo ago> postgresql also does not synchronously replicate By default. Generally your primary database is in a completely different failure category than a kubernetes node running an ephemeral workflow pod.
- 0cf8612b2e1e 5mo agoEither you have durable storage or you do not. SQLite and Postgres can both ensure local durability of commits. If you want distributed durability, you need to ship that data elsewhere. That is another Postgres node, object store, whatever that’s still an external dependency.
- paulddraper 5mo agoNot for free, but without the needing additional software. synchronous_commit = on
- 0cf8612b2e1e 5mo agoThat’s about the local transaction, not replication. SQLite WAL also gives you strict durability. PRAGMA synchronous = full