| From: | "Syed, Rahila" <Rahila(dot)Syed(at)nttdata(dot)com> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Cc: | "Michael Paquier (michael(dot)paquier(at)gmail(dot)com)" <michael(dot)paquier(at)gmail(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
| Subject: | Re: [REVIEW] Re: Compression of full-page-writes |
| Date: | 2015-03-05 12:14:04 |
| Message-ID: | C3C878A2070C994B9AE61077D46C3846589B550A@MAIL703.KDS.KEANE.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
Please find attached a patch. As discussed, flag to denote compression and presence of hole in block image has been added in 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.
| Attachment | Content-Type | Size |
|---|---|---|
| Support-compression-of-full-page-writes-in-WAL_v23.patch | application/octet-stream | 23.9 KB |
| compress_run.bash | application/octet-stream | 655 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sandro Santilli | 2015-03-05 12:20:20 | contraints_exclusion fails to refute simple condition |
| Previous Message | Etsuro Fujita | 2015-03-05 12:08:06 | Re: Optimization for updating foreign tables in Postgres FDW |