PostgreSQL: Is there any way to further optimise ASYNC replication towards less data loss during failover?
0
votes
0
answers
80
views
We are looking to see if there any further optimisations that can be done in PostgreSQL(13)
ASYNC replication
to make data loss
near to zero as possible when a failover
is triggered during disaster. We don't want change to synchronous replication
as with the testing the TPS
is really low comparing with ASYNC
method.
We see an average write lag
of 200-300KBs and at peak traffic up to 20MB. Is there any optimisations can do on WAL
level? Any other area to tune?
**UPDATE**
Could wal_compression
help optimise this?
Asked by goodfella
(595 rep)
Oct 4, 2024, 09:16 AM
Last activity: Oct 8, 2024, 03:46 AM
Last activity: Oct 8, 2024, 03:46 AM