Re: Performance Improvement by reducing WAL for Update Operation

On Wed, Jan 15, 2014 at 5:58 PM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> On Fri, Jan 10, 2014 at 9:12 PM, Robert Haas <robertmhaas@gmail.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