Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] WAL archiving idle database

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Brian Wipf <brian(at)clickspace(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] WAL archiving idle database
Date: 2007-10-26 23:15:59
Message-ID: 1193440559.7624.106.camel@dogma.ljc.laika.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
On Fri, 2007-10-26 at 18:06 -0500, Kevin Grittner wrote:
> >>> On Fri, Oct 26, 2007 at  5:47 PM, in message <695(dot)1193438855(at)sss(dot)pgh(dot)pa(dot)us>,
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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.  We have software to ensure that the warm
> standby instances are not getting stale, and that's pretty simple
> with the current behavior.  We don't have a bandwidth or storage
> space issue because we zero out the unused portion of the WAL file
> and gzip it -- an empty file's about 16 KB.  Checking that the whole
> system is healthy gets a lot more complicated if we stop sending
> empty WAL files.
>  
> Could this at least be a configurable option?
>  

A good point.

Keep in mind that even in the current system, your configuration is
variable based on the checkpoint_timeout setting.

Regards,
	Jeff Davis


In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2007-10-26 23:24:39
Subject: Re: [HACKERS] WAL archiving idle database
Previous:From: Tom LaneDate: 2007-10-26 23:15:37
Subject: Re: [HACKERS] WAL archiving idle database

pgsql-general by date

Next:From: Tom LaneDate: 2007-10-26 23:24:39
Subject: Re: [HACKERS] WAL archiving idle database
Previous:From: Tom LaneDate: 2007-10-26 23:15:37
Subject: Re: [HACKERS] WAL archiving idle database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group