Re: archive_timeout? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: archive_timeout?
Date
Msg-id 17470.1160489496@sss.pgh.pa.us
Whole thread Raw
In response to archive_timeout?  (Tatsuo Ishii <ishii@sraoss.co.jp>)
List pgsql-hackers
Tatsuo Ishii <ishii@sraoss.co.jp> writes:
> If archive_timeout is set to non 0, it seems an archive log segment is
> created every time checkpoint occurs even there's no database
> updation. This leads to creating 16MB log segment files every 5
> minutes (default checkpoint period), which will in turn produce 4.6GB
> log segments with bogus data. Is this normal?

Yeah, that was intentional, see discussion a few weeks ago.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: archive_timeout?
Next
From: Andrew Dunstan
Date:
Subject: Re: Upgrading a database dump/restore