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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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