Re: Performance Improvement by reducing WAL for Update Operation

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Performance Improvement by reducing WAL for Update Operation
Дата
Msg-id 52F256D7.2070509@vmware.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>)
Re: Performance Improvement by reducing WAL for Update Operation  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On 02/05/2014 04:48 PM, Amit Kapila wrote:
> I have done one test where there is a large suffix match, but
> not large enough that it can compress more than 75% of string,
> the CPU overhead with wal-update-prefix-suffix-encode-1.patch is
> not much, but there is no I/O reduction as well.

Hmm, it's supposed to compress if you save at least 25%, not 75%. 
Apparently I got that backwards in the patch...

- Heikki

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: Misaligned BufferDescriptors causing major performance problems on AMD
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Misaligned BufferDescriptors causing major performance problems on AMD