Re: [REVIEW] Re: Compression of full-page-writes
От
Andres Freund
Тема
Re: [REVIEW] Re: Compression of full-page-writes
Дата
Msg-id
20150224143654.GB19861@awork2.anarazel.de
Ответ на
Re: [REVIEW] Re: Compression of full-page-writes (Michael Paquier)
Список
Дерево обсуждения
Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Rahila Syed <rahilasyed.90@gmail.com>
Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Pavan Deolasee <pavan.deolasee@gmail.com>
Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
[REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Claudio Freire <klaussfreire@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndquadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndquadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Pavan Deolasee <pavan.deolasee@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Robert Haas <robertmhaas@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Abhijit Menon-Sen <ams@2ndQuadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Pavan Deolasee <pavan.deolasee@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: [REVIEW] Re: Compression of full-page-writes Pavan Deolasee <pavan.deolasee@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Simon Riggs <simon@2ndQuadrant.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Simon Riggs <simon@2ndQuadrant.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Rahila Syed <rahilasyed90@gmail.com>
Re: Compression of full-page-writes Satoshi Nagayasu <snaga@uptime.jp>
Re: Compression of full-page-writes Satoshi Nagayasu <snaga@uptime.jp>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Compression of full-page-writes Jeff Davis <pgsql@j-davis.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes "ktm@rice.edu" <ktm@rice.edu>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Claudio Freire <klaussfreire@gmail.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Stephen Frost <sfrost@snowman.net>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Rahila Syed <rahilasyed.90@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Rahila Syed <rahilasyed.90@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Robert Haas <robertmhaas@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Robert Haas <robertmhaas@gmail.com>
Re: Compression of full-page-writes Simon Riggs <simon@2ndQuadrant.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Haribabu Kommi <kommi.haribabu@gmail.com>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Michael Paquier <michael.paquier@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Sameer Thakur <samthakur74@gmail.com>
Re: Compression of full-page-writes Tom Lane <tgl@sss.pgh.pa.us>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Sameer Thakur <samthakur74@gmail.com>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Haribabu kommi <haribabu.kommi@huawei.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Haribabu kommi <haribabu.kommi@huawei.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Haribabu kommi <haribabu.kommi@huawei.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Haribabu kommi <haribabu.kommi@huawei.com>
Re: Compression of full-page-writes Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes Jesper Krogh <jesper@krogh.cc>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes "ktm@rice.edu" <ktm@rice.edu>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes "ktm@rice.edu" <ktm@rice.edu>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Andres Freund <andres@2ndquadrant.com>
Re: Compression of full-page-writes KONDO Mitsumasa <kondo.mitsumasa@lab.ntt.co.jp>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Robert Haas <robertmhaas@gmail.com>
Re: Compression of full-page-writes "ktm@rice.edu" <ktm@rice.edu>
Re: Compression of full-page-writes Robert Haas <robertmhaas@gmail.com>
Re: Compression of full-page-writes "ktm@rice.edu" <ktm@rice.edu>
Re: Compression of full-page-writes Tom Lane <tgl@sss.pgh.pa.us>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Amit Kapila <amit.kapila16@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Bruce Momjian <bruce@momjian.us>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Peter Geoghegan <pg@heroku.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
Re: Compression of full-page-writes Peter Geoghegan <pg@heroku.com>
Re: Compression of full-page-writes Nikhil Sontakke <nikkhils@gmail.com>
Re: Compression of full-page-writes Fujii Masao <masao.fujii@gmail.com>
On 2015-02-24 16:03:41 +0900, Michael Paquier wrote:
> Looking at this code, I think that it is really confusing to move the data
> related to the status of the backup block out of XLogRecordBlockImageHeader
> to the chunk ID itself that may *not* include a backup block at all as it
> is conditioned by the presence of BKPBLOCK_HAS_IMAGE.
What's the problem here? We could actually now easily remove
BKPBLOCK_HAS_IMAGE and replace it by a chunk id.
> the idea of having the backup block data in its dedicated header with bits
> stolen from the existing fields, perhaps by rewriting it to something like
> that:
> typedef struct XLogRecordBlockImageHeader {
> uint32 length:15,
> hole_length:15,
> is_compressed:1,
> is_hole:1;
> } XLogRecordBlockImageHeader;
> Now perhaps I am missing something and this is really "ugly" ;)
I think it's fantastically ugly. We'll also likely want different
compression formats and stuff in the not too far away future. This will
just end up being a pain.
Greetings,
Andres Freund
-- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления