Postgres Pro
Downloads
Home   >   mailing lists

archive_timeout, checkpoint_timeout - Mailing list pgsql-general

From Rob Adams
Subject archive_timeout, checkpoint_timeout
Date
Msg-id 489110D9.1000503@cox.net
Whole thread Raw
Responses Re: archive_timeout, checkpoint_timeout
Re: archive_timeout, checkpoint_timeout
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Richard Broersma"
Date:
Subject: Re: Declaring constants in SQL
Next
From: Craig Ringer
Date:
Subject: Re: Connecting to an existing transaction state.