Re: [REVIEW] Re: Compression of full-page-writes

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: [REVIEW] Re: Compression of full-page-writes
Дата
Msg-id CA+TgmobGOaXsJ8to4qDUBxgQjE-+TmSjxizgVx30RKYRdOFWfQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [REVIEW] Re: Compression of full-page-writes  (Michael Paquier <michael.paquier@gmail.com>)
Ответы Re: [REVIEW] Re: Compression of full-page-writes  (Michael Paquier <michael.paquier@gmail.com>)
Re: [REVIEW] Re: Compression of full-page-writes  (Rahila Syed <rahilasyed.90@gmail.com>)
Список pgsql-hackers
On Wed, Nov 26, 2014 at 11:00 PM, Michael Paquier
<michael.paquier@gmail.com> wrote:
> On Wed, Nov 26, 2014 at 8:27 PM, Syed, Rahila <Rahila.Syed@nttdata.com> wrote:
>> Don't we need to initialize doPageCompression  similar to doPageWrites in InitXLOGAccess?
> Yep, you're right. I missed this code path.
>
>> Also , in the earlier patches compression was set 'on' even when fpw GUC is 'off'. This was to facilitate
compressionof FPW which are forcibly written even when fpw GUC is turned off.
 
>>  doPageCompression in this patch is set to true only if value of fpw GUC is 'compress'. I think its better to
compressforcibly written full page writes.
 
> Meh? (stealing a famous quote).
> This is backward-incompatible in the fact that forcibly-written FPWs
> would be compressed all the time, even if FPW is set to off. The
> documentation of the previous patches also mentioned that images are
> compressed only if this parameter value is switched to compress.

If we have a separate GUC to determine whether to do compression of
full page writes, then it seems like that parameter ought to apply
regardless of WHY we are doing full page writes, which might be either
that full_pages_writes=on in general, or that we've temporarily turned
them on for the duration of a full backup.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



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

Предыдущее
От: Alexander Kukushkin
Дата:
Сообщение: Report search_path value back to the client.
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Testing DDL deparsing support