Horton

Re: Performance Improvement by reducing WAL for Update Operation

Andres Freund <andres@2ndquadrant.com>

View thread View on postgr.es
From: Andres Freund <andres@2ndquadrant.com>
To: Peter Geoghegan <pg@heroku.com>,Fujii Masao <masao.fujii@gmail.com>
Cc: Bruce Momjian <bruce@momjian.us>, Robert Haas <robertmhaas@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, Heikki Linnakangas <hlinnakangas@vmware.com>, pgsql-hackers <pgsql-hackers@postgresql.org>, Mike Blackwell <mike.blackwell@rrd.com>
Date: 2014-02-04T21:58:08Z
Lists: pgsql-hackers 
On February 4, 2014 10:50:10 PM CET, Peter Geoghegan <pg@heroku.com> wrote:
>On Tue, Feb 4, 2014 at 11:11 AM, Andres Freund <andres@2ndquadrant.com>
>wrote:
>>> Does this feature relate to compression of WAL page images at all?
>>
>> No.
>
>So the obvious question is: where, if anywhere, do the two efforts
>(this patch, and Fujii's patch) overlap? Does Fujii have any concerns
>about this patch as it relates to his effort to compress FPIs?

I think there's zero overlap. They're completely complimentary features. It's not like normal WAL records have an irrelevant volume.

Andres

-- 
Please excuse brevity and formatting - I am writing this on my mobile phone.

Andres Freund	                   http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Commits

  1. Flush stderr and stdout in isolation tester.