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

Поиск
Список
Период
Сортировка
От Syed, Rahila
Тема Re: [REVIEW] Re: Compression of full-page-writes
Дата
Msg-id C3C878A2070C994B9AE61077D46C3846589B550A@MAIL703.KDS.KEANE.COM
обсуждение исходный текст
Ответ на Re: [REVIEW] Re: Compression of full-page-writes  ("Syed, Rahila" <Rahila.Syed@nttdata.com>)
Ответы Re: [REVIEW] Re: Compression of full-page-writes  (Michael Paquier <michael.paquier@gmail.com>)
Re: [REVIEW] Re: Compression of full-page-writes  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
Hello,

Please find attached  a patch. As discussed, flag to denote compression and presence of hole in block image has been
addedin XLogRecordImageHeader rather than block header.   

Following are WAL numbers based on attached  test script  posted by Michael earlier in the thread.

                                                      WAL generated
FPW compression on           122.032 MB

FPW compression off           155.223 MB

HEAD                                          155.236 MB

Compression : 21 %
Number of block images generated in WAL :   63637


Thank you,
Rahila Syed


______________________________________________________________________
Disclaimer: This email and any attachments are sent in strictest confidence
for the sole use of the addressee and may contain legally privileged,
confidential, and proprietary data. If you are not the intended recipient,
please advise the sender by replying promptly to this email and then delete
and destroy this email and any attachments without any further use, copying
or forwarding.

Вложения

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

Предыдущее
От: Etsuro Fujita
Дата:
Сообщение: Re: Optimization for updating foreign tables in Postgres FDW
Следующее
От: Sandro Santilli
Дата:
Сообщение: contraints_exclusion fails to refute simple condition