Re: checkpoint_timout with no WAL activity

On Mon, Nov 7, 2016 at 9:14 PM, amul sul <sulamul(at)gmail(dot)com> wrote:
> On Mon, Nov 7, 2016 at 4:20 PM, Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com> 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