Re: Improving compressibility of WAL files - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Improving compressibility of WAL files
Date
Msg-id 200901091431.n09EVW210201@momjian.us
Whole thread Raw
In response to Re: Improving compressibility of WAL files  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Improving compressibility of WAL files  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Improving compressibility of WAL files  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Tom Lane wrote:
> >> Isn't this redundant given the existence of pglesslog?
> 
> > It does the same as pglesslog, but is simpler to use because it is
> > automatic.
> 
> Which also means that everyone pays the performance penalty whether
> they get any benefit or not.  The point of the external solution
> is to do the work only in installations that get some benefit.
> We've been over this ground before...

If there is a performance penalty, you are right, but if the zeroing is
done as part of the archiving, it seems near zero cost enough to do it
all the time, no?

--  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: Including kerberos realm
Next
From: Andrew Dunstan
Date:
Subject: parallel restore