Re: Performance Improvement by reducing WAL for Update Operation

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Performance Improvement by reducing WAL for Update Operation
Дата
Msg-id CAGTBQpa3G_TUOHJhb7oujbVSFQuekJ7H0ajMKO2Vovfb8nagNw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance Improvement by reducing WAL for Update Operation  (Amit Kapila <amit.kapila16@gmail.com>)
Ответы Re: Performance Improvement by reducing WAL for Update Operation  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On Thu, Feb 13, 2014 at 1:20 AM, Amit Kapila <amit.kapila16@gmail.com> wrote:
> Here one of the improvements which can be done is that after prefix-suffix
> match, instead of going byte-by-byte copy as per LZ format we can directly
> copy all the remaining part of tuple but I think that would require us to use
> some different format than LZ which is also not too difficult to do, but the
> question is do we really need such a change to handle the above kind of
> worst case.


Why use LZ at all? Why not *only* prefix/suffix?



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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Per table autovacuum vacuum cost limit behaviour strange
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Performance Improvement by reducing WAL for Update Operation