Re: Reduction in WAL for UPDATEs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reduction in WAL for UPDATEs
Дата
Msg-id 12291.1175042923@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Reduction in WAL for UPDATEs  ("Simon Riggs" <simon@2ndquadrant.com>)
Ответы Re: Reduction in WAL for UPDATEs  ("Simon Riggs" <simon@2ndquadrant.com>)
Список pgsql-hackers
"Simon Riggs" <simon@2ndquadrant.com> writes:
> It seems possible to reduce overall WAL volume by roughly 25% on common
> workloads by optimising the way UPDATE statements generate WAL.

This seems a huge amount of work to optimize *one* benchmark.  If it
weren't so narrowly focused on the properties of a particular benchmark
(mostly UPDATE, mostly a few columns in wide tuples), I'd get more
excited.  The extra time spent holding exclusive lock on the page
doesn't sound attractive either ...
        regards, tom lane


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

Предыдущее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Re: Guarenteeing complex referencial integrity through custom triggers
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Concurrent connections in psql