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

From Tom Lane
Subject Re: Improving compressibility of WAL files
Date
Msg-id 25978.1231516935@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improving compressibility of WAL files  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Bruce Momjian <bruce@momjian.us> writes:
> Tom Lane wrote:
>> 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?

It's the same cost no matter which process does it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Improving compressibility of WAL files
Next
From: Simon Riggs
Date:
Subject: Re: SET TRANSACTION and SQL Standard