Create WAL at interval, but only if data changed

4 votes

1 answer

239 views

postgresql postgresql-8.4 write-ahead-logging

                          I have a PostgreSQL 8.4 installation, and I have configured the archive_timeout setting to 5 minutes to improve the odds that I always have complete WAL file to apply in case of system failure.

However, this creates a LOT of big files, even if nothing has changed!  Is there a way to tell PostgreSQL to only create these WAL files at the timeout interval IF something has changed?

Asked by TSG (193 rep)

Mar 7, 2018, 11:06 PM
Last activity: Jun 2, 2025, 03:09 PM

Create WAL at interval, but only if data changed

Related Questions