Re: Compression of full-page-writes

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Compression of full-page-writes
Дата
Msg-id CAB7nPqQYU1SQyEqGgwauhtQadE4-by4042AEOk8WFYNCO1GBoA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Compression of full-page-writes  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Compression of full-page-writes  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
On Tue, Dec 9, 2014 at 4:09 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>
> On Sun, Dec 7, 2014 at 9:30 PM, Simon Riggs <simon@2ndquadrant.com> wrote:
> > * parameter should be SUSET - it doesn't *need* to be set only at
> > server start since all records are independent of each other
>
> Why not USERSET?  There's no point in trying to prohibit users from
> doing things that will cause bad performance because they can do that
> anyway.

Using SUSET or USERSET has a small memory cost: we should
unconditionally palloc the buffers containing the compressed data
until WAL is written out. We could always call an equivalent of
InitXLogInsert when this parameter is updated but that would be
bug-prone IMO and it does not plead in favor of code simplicity.
Regards,
-- 
Michael



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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Turning off HOT/Cleanup sometimes
Следующее
От: "Amit Langote"
Дата:
Сообщение: Re: On partitioning