Re: [HACKERS] WAL archiving idle database - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] WAL archiving idle database
Date
Msg-id 1175.1193440537@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] WAL archiving idle database  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-general
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> On Fri, Oct 26, 2007 at  5:47 PM, in message <695.1193438855@sss.pgh.pa.us>,
> Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> And after
>> each archive_timeout, we test to see if we need to flush the current WAL
>> segment out to the archive; which is determined by whether the write
>> pointer is currently exactly at the start of a segment or not.

> Hmmm...  We would actually prefer to get the WAL file at the
> specified interval.

Well, if it's a feature not a bug, that's fine with me.  I wonder though
how predictable the behavior will really be with 8.3's distributed
checkpoints ... you might need to find another way anyhow.

            regards, tom lane

pgsql-general by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] WAL archiving idle database
Next
From: Jeff Davis
Date:
Subject: Re: [HACKERS] WAL archiving idle database