On Mon, Nov 7, 2016 at 9:14 PM, amul sul <sulamul@xxxxxxxxx> wrote: > On Mon, Nov 7, 2016 at 4:20 PM, Tom DalPozzo <t.dalpozzo@xxxxxxxxx> wrote: >> 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 Out of curiosity, which version are you using? That's 9.6, no? -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
