Re: Core team statement on replication in PostgreSQL - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Core team statement on replication in PostgreSQL
Date
Msg-id 200806100146.m5A1k6125570@momjian.us
Whole thread Raw
In response to Re: Core team statement on replication in PostgreSQL  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
Responses Re: Core team statement on replication in PostgreSQL  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Core team statement on replication in PostgreSQL  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Andreas 'ads' Scherbaum wrote:
> On Fri, 30 May 2008 16:22:41 -0400 (EDT) Greg Smith wrote:
> 
> > On Fri, 30 May 2008, Andreas 'ads' Scherbaum wrote:
> > 
> > > Then you ship 16 MB binary stuff every 30 second or every minute but
> > > you only have some kbyte real data in the logfile.
> > 
> > Not if you use pg_clearxlogtail ( 
> > http://www.2ndquadrant.com/replication.htm ), which got lost in the giant 
> > March commitfest queue but should probably wander into contrib as part of 
> > 8.4.
> 
> Yes, this topic was discussed several times in the past but to
> solve this it needs a patch/solution which is integrated into PG
> itself, not contrib.

Agreed.  I realize why we are not zeroing those bytes (for performance),
but can't we have the archiver zero those bytes before calling the
'archive_command'?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Core team statement on replication in PostgreSQL
Next
From: Alvaro Herrera
Date:
Subject: Re: Core team statement on replication in PostgreSQL