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
|
Список | 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 по дате отправления: