Re: Core team statement on replication in PostgreSQL

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. +