Re: archive_timeout?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Davis <pgsql(at)j-davis(dot)com>
Cc: Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: archive_timeout?
Date: 2006-10-10 17:12:16
Message-ID: 25993.1160500336@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jeff Davis <pgsql(at)j-davis(dot)com> writes:
> There should be a documentation note to let people know that the archive
> will grow even when idle. Perhaps we should suggest compression in the
> docs so that people don't get worried about many gigabytes of mostly-
> empty files filling up their backup storage.

Actually, per the previous discussion: if you want to reduce WAL traffic
then one of the most important things to do is stretch out
checkpoint_timeout.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2006-10-10 17:55:57 more anti-postgresql FUD
Previous Message Jeff Davis 2006-10-10 17:07:02 Re: archive_timeout?