Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation

Поиск
Список
Период
Сортировка
От Jesper Krogh
Тема Re: Re: [WIP] Performance Improvement by reducing WAL for Update Operation
Дата
Msg-id 7FCED621-DFC1-437D-BCD3-F2FE6D1F0EEC@krogh.cc
обсуждение исходный текст
Ответ на Re: [WIP] Performance Improvement by reducing WAL for Update Operation  (Noah Misch <noah@leadboat.com>)
Список pgsql-hackers
> Naturally, there are other compression and delta encoding schemes.  Does
> anyone feel the need to explore further alternatives?
>
> We might eventually find the need for multiple, user-selectable, WAL
> compression strategies.  I don't recommend taking that step yet.
>

my currently implemented compression strategy is to run the wal block through gzip in the archive command. compresses
prettynicely and achieved 50%+ in my workload (generally closer to 70) 

on a multi core system it will take more cpu time but on a different core and not have any effect on tps.

General compression should probably only be applied if it have positive gain on tps you could.

Jesper





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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: proposal - assign result of query to psql variable
Следующее
От: Jan Wieck
Дата:
Сообщение: Re: autovacuum truncate exclusive lock round two