Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Date
Msg-id CA+TgmoaYdojYbCSOQ9Uyk-dyNdFEnNEzfKT71WX-jN3TWE8kCg@mail.gmail.com
Whole thread Raw
In response to Re: [WIP] Performance Improvement by reducing WAL for Update Operation  (Noah Misch <noah@leadboat.com>)
List pgsql-hackers
On Tue, Oct 23, 2012 at 8:21 PM, Noah Misch <noah@leadboat.com> wrote:
> -Patch-             -tps@-c1-   -tps@-c2-   -tps@-c8-   -WAL@-c8-
> HEAD,-F80           816         1644        6528        1821 MiB
> xlogscale,-F80      824         1643        6551        1826 MiB
> xlogscale+lz,-F80   717         1466        5924        1137 MiB
> xlogscale+lz,-F100  753         1508        5948        1548 MiB

Ouch.  I've been pretty excited by this patch, but I don't think we
want to take an "optimization" that produces a double-digit hit at 1
client and doesn't gain even at 8 clients. I'm surprised this is
costing that much, though.  It doesn't seem like it should.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Brar Piening
Date:
Subject: Re: Visual Studio 2012 RC
Next
From: Jan Wieck
Date:
Subject: autovacuum truncate exclusive lock round two