Stephen Frost wrote: > The downside with any snapshot-style approach is that it means that when > you have a failure, you have to go through and replay all the WAL since > the last checkpoint, which is single-threaded and can take a large > amount of time. > > When doing your testing, I'd strongly recommend that you have a large > max_wal_size, run a large pgbench which writes a lot of data, and see > how long a failover takes with this system. Then "checkpoint_timeout" should also be large, right? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
