Postgres Pro
Downloads
Home   >   mailing lists

checkpoint_timout with no WAL activity - Mailing list pgsql-general

From Tom DalPozzo
Subject checkpoint_timout with no WAL activity
Date
Msg-id CAK77FCQXY_7VQjFQjVEpRMemVRQCyMRW7w2G2foV+yDLOf=z9g@mail.gmail.com
Whole thread Raw
Responses Re: checkpoint_timout with no WAL activity  (amul sul <sulamul@gmail.com>)
List pgsql-general
Tree view
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



pgsql-general by date:

Previous
From: Arthur Silva
Date:
Subject: Changing foreign key referential actions in big databases
Next
From: Albe Laurenz
Date:
Subject: Re: What is the best thing to do with PUBLIC schema in Postgresql database