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.
pgsql-general by date
|Next:||From: Craig Ringer||Date: 2008-07-31 01:15:05|
|Subject: Re: Connecting to an existing transaction state.|
|Previous:||From: Richard Broersma||Date: 2008-07-30 20:53:27|
|Subject: Re: Declaring constants in SQL|