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: 489110D9.1000503@cox.net (view raw or flat)
Thread:
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.

Thanks,
Rob Adams

Responses

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-2014 The PostgreSQL Global Development Group