On Mon, Nov 7, 2016 at 4:20 PM, Tom DalPozzo <t.dalpozzo@xxxxxxxxx> wrote: > Hi, > I have: > checkpoint_timeout = 2min > wal_level = archive > archive_mode=on > archive_timeout = 30 > > With NO dbase activity, I see the WAL being modified every 2min (and, > consequently, one WAL file archived every 2min too ). > > Is it right? I read: "If no WAL has been written since the previous > checkpoint, new checkpoints will be skipped even if checkpoint_timeout has > passed." I guess archive_timeout forcing to switch new WAL file, see this : https://www.postgresql.org/docs/devel/static/runtime-config-wal.html#GUC-ARCHIVE-TIMEOUT Regards, Amul -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
