Re: logical changeset generation v6.2

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: logical changeset generation v6.2
Дата
Msg-id
CA+TgmoaQK9awbGTg8CverEQaopWkX1OCZN3Pwsxhpr0wLUEYAA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Andres Freund
Дата:
От: Andres Freund
Дата:
FAQ