Skip site navigation (1) Skip section navigation (2)

archive_timeout, checkpoint_timeout

From: Rob Adams <robfadams(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: archive_timeout, checkpoint_timeout
Date: 2008-07-31 01:09:45
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
We want to use an archive_timeout of ~1min to minimize data loss in the 
event of hardware failure (archive script includes external b/u).

archive_timeout only seems to work if it's >= checkpoint_timeout.

Could someone please explain in layman's terms the implications of using 
  a checkpoint_timeout of ~1min as well?  Is it a bad idea?

We use PostgreSQL 8.3 on Windows.

Rob Adams


pgsql-general by date

Next:From: Craig RingerDate: 2008-07-31 01:15:05
Subject: Re: Connecting to an existing transaction state.
Previous:From: Richard BroersmaDate: 2008-07-30 20:53:27
Subject: Re: Declaring constants in SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group