checkpoint_timout with no WAL activity

From: Tom DalPozzo <t(dot)dalpozzo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: checkpoint_timout with no WAL activity
Date: 2016-11-07 10:50:27
Message-ID: CAK77FCQXY_7VQjFQjVEpRMemVRQCyMRW7w2G2foV+yDLOf=z9g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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."

Regards
Pupillo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2016-11-07 11:00:34 Re: What is the best thing to do with PUBLIC schema in Postgresql database
Previous Message Arthur Silva 2016-11-07 10:09:23 Changing foreign key referential actions in big databases