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

Re: [HACKERS] WAL archiving idle database

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jeff Davis" <pgsql(at)j-davis(dot)com>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "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:06:10
Message-ID: 47222C91.EE98.0025.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
>>> 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?
 
-Kevin
 



In response to

Responses

pgsql-hackers by date

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

pgsql-general by date

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

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