Re: logical changeset generation v6.2
От
Robert Haas
Тема
Re: logical changeset generation v6.2
Дата
Msg-id
CA+TgmoaQK9awbGTg8CverEQaopWkX1OCZN3Pwsxhpr0wLUEYAA@mail.gmail.com
Ответ на
Re: logical changeset generation v6.2 (Andres Freund)
Список
Дерево обсуждения
logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Peter Eisentraut <peter_e@gmx.net>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Peter Eisentraut <peter_e@gmx.net>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Peter Eisentraut <peter_e@gmx.net>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Peter Geoghegan <pg@heroku.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: logical changeset generation v6 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6 Peter Geoghegan <pg@heroku.com>
Re: logical changeset generation v6 Peter Eisentraut <peter_e@gmx.net>
Re: logical changeset generation v6 Peter Geoghegan <pg@heroku.com>
Re: logical changeset generation v6 Magnus Hagander <magnus@hagander.net>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Magnus Hagander <magnus@hagander.net>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6 Peter Geoghegan <pg@heroku.com>
Re: logical changeset generation v6 Fujii Masao <masao.fujii@gmail.com>
Re: logical changeset generation v6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Kevin Grittner <kgrittn@ymail.com>
Re: logical changeset generation v6.1 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Thom Brown <thom@linux.com>
Re: logical changeset generation v6.1 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.1 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.1 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Hannu Krosing <hannu@krosing.net>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 "ktm@rice.edu" <ktm@rice.edu>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 David Fetter <david@fetter.org>
Re: logical changeset generation v6.2 Peter Geoghegan <pg@heroku.com>
Re: logical changeset generation v6.2 Hannu Krosing <hannu@krosing.net>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Heikki Linnakangas <hlinnakangas@vmware.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.2 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.2 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.4 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.4 Hannu Krosing <hannu@2ndQuadrant.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Hannu Krosing <hannu@2ndQuadrant.com>
Re: logical changeset generation v6.4 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.4 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.4 Merlin Moncure <mmoncure@gmail.com>
Re: logical changeset generation v6.5 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.5 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.5 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.5 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.5 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.5 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.5 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.5 Steve Singer <steve@ssinger.info>
Re: logical changeset generation v6.5 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.5 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.5 Peter Eisentraut <peter_e@gmx.net>
Re: logical changeset generation v6.5 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.5 Peter Eisentraut <peter_e@gmx.net>
Re: logical changeset generation v6.6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.6 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: logical changeset generation v6.7 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: logical changeset generation v6.7 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: logical changeset generation v6.7 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 David Rowley <dgrowleyml@gmail.com>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 David Rowley <dgrowleyml@gmail.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Tom Lane <tgl@sss.pgh.pa.us>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: logical changeset generation v6.8 Tom Lane <tgl@sss.pgh.pa.us>
Re: logical changeset generation v6.8 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.8 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.7 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.7 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.7 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.7 Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: logical changeset generation v6.6 Robert Haas <robertmhaas@gmail.com>
Re: logical changeset generation v6.6 Andres Freund <andres@2ndquadrant.com>
Re: logical changeset generation v6.6 Andres Freund <andres@2ndquadrant.com>
On Mon, Oct 21, 2013 at 1:52 PM, Andres Freund wrote: >> > In my opinion, (4) is too ugly to consider. I think that if we start >> > playing games like this, we're opening up the doors to lots of subtle >> > bugs and future architectural pain that will be with us for many, many >> > years to come. I believe we will bitterly regret any foray into this >> > area. >> >> Hm. After looking at the required code - which you obviously cannot have >> yet - it's not actually too bad. Will post a patch implementing it later. >> >> I don't really buy the architectural argument since originally cmin/cmax >> *were* both stored. It's not something we're just inventing now. We just >> optimized that away but now have discovered that's not always a good >> idea and thus don't always use the optimization. >> >> The actual decoding code shrinks by about 200 lines using this logic >> which is a hint that it's not a bad idea. > > So, here's a preliminary patch to see how this would look. It'd be great > of you comment if you still think it's a completel no-go. > > If it were for real, it'd need to be split and some minor things would > need to get adjusted, but I think it's easier to review it seing both > sides at once. I think it's a complete no-go. Consider, e.g., the comment for MaxTupleAttributeNumber, which you've blithely falsified. Even if you update the comment and the value, I'm not inspired by the idea of subtracting 32 from that number; even if it weren't already too small, it would break pg_upgrade for any users who are on the edge. Things aren't looking too good for anything that uses HeapTupleFields, either; consider rewrite_heap_tuple(). -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления