Re: Performance Improvement by reducing WAL for Update Operation

Поиск
Список
Период
Сортировка
От Amit Kapila
Тема Re: Performance Improvement by reducing WAL for Update Operation
Дата
Msg-id CAA4eK1LhA+A8JHHwD3AtOB8yd2=DmEaCy9jcc6Q6H3HKZjQ==g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance Improvement by reducing WAL for Update Operation  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Performance Improvement by reducing WAL for Update Operation
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: plpgsql.warn_shadow