Re: Performance Improvement by reducing WAL for Update Operation

On Wed, Jan 15, 2014 at 5:58 PM, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> On Fri, Jan 10, 2014 at 9:12 PM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>
> Performance Data
> -----------------------------
> Non-default settings:
> autovacuum =off
> checkpoint_segments =128
> checkpoint_timeout = 10min
>
> Unpatched
> -------------------
> testname | wal_generated |
> duration
> ----------------------------------------------------------+----------------------+------------------
> one short and one long field, no change | 1054923224 | 33.101135969162
>
> After pgrb_delta_encoding_v4
> ---------------------------------------------
>
> testname | wal_generated |
> duration
> ----------------------------------------------------------+----------------------+------------------
> one short and one long field, no change | 877859144 | 30.6749138832092
>
>
> Temporary Changes
> (Revert Max Chunksize = 4 and logic of finding longer match)
> ---------------------------------------------------------------------------------------------
>
> testname | wal_generated |
> duration
> ----------------------------------------------------------+----------------------+------------------
> one short and one long field, no change | 677337304 | 25.4048750400543
>

Sorry, minor correction in last mail, the last data (Temporary Changes) is
just by reverting logic of finding longer match in pgrb_find_match().

With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com