Re: Performance Improvement by reducing WAL for Update Operation

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Performance Improvement by reducing WAL for Update Operation
Дата
Msg-id CAM3SWZQnmEpiACpD1qX+HO0CzLVCkbcAdTdjS9iikbmJhhYKtw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance Improvement by reducing WAL for Update Operation  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: Performance Improvement by reducing WAL for Update Operation  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Wed, Feb 5, 2014 at 12:50 AM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
>> I think there's zero overlap. They're completely complimentary features.
>> It's not like normal WAL records have an irrelevant volume.
>
>
> Correct. Compressing a full-page image happens on the first update after a
> checkpoint, and the diff between old and new tuple is not used in that case.

Uh, I really just meant that one thing that might overlap is
considerations around the choice of compression algorithm. I think
that there was some useful discussion of that on the other thread as
well.


-- 
Peter Geoghegan



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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: narwhal and PGDLLIMPORT
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: jsonb and nested hstore