3 ms·
We use PostgreSQL locally but moved our production database over to AWS Aurora. If I use `SET synchronous_commit = off;` in my Rails code will Aurora also mimi
by kelseydh 2y ago
We use PostgreSQL locally but moved our production database over to AWS Aurora.
If I use `SET synchronous_commit = off;` in my Rails code will Aurora also mimic this behaviour?
- shayonj 2y agoYes, i touched a bit on it towards the end. If you turn it off, Aurora won't wait for 4 out of 6 nodes to acknowledge the commit (https://aws.amazon.com/blogs/database/amazon-aurora-postgresql-parameters-part-2-replication-security-and-logging/ https://aws.amazon.com/blogs/database/amazon-aurora-postgres...)