Re: AdvanceXLInsertBuffer vs. WAL segment compressibility - Mailing list pgsql-hackers

From Chapman Flack
Subject Re: AdvanceXLInsertBuffer vs. WAL segment compressibility
Date
Msg-id 5796D9EB.6070407@anastigmatix.net
Whole thread Raw
In response to Re: AdvanceXLInsertBuffer vs. WAL segment compressibility  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: AdvanceXLInsertBuffer vs. WAL segment compressibility  (Amit Kapila <amit.kapila16@gmail.com>)
List pgsql-hackers
On 07/25/16 22:09, Michael Paquier wrote:

> This is over-complicating things for little gain. The new behavior of
> filling in with zeros the tail of a segment makes things far better
> when using gzip in archive_command.

Then how about filling with actual zeros, instead of with mostly-zeros
as is currently done?  That would work just as well for gzip, and would
not sacrifice the ability to do 100x better than gzip.

-Chap



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Next
From: David Fetter
Date:
Subject: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE