Re: ALTER TABLE ADD COLUMN fast default

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: ALTER TABLE ADD COLUMN fast default
Дата
Msg-id
20180220200618.4tsle6uburodi2x7@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Thomas Munro <thomas.munro@enterprisedb.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Thomas Munro <thomas.munro@enterprisedb.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Petr Jelinek <petr.jelinek@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: Re: ALTER TABLE ADD COLUMN fast default David Steele <david@pgmasters.net>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Andres Freund <andres@anarazel.de>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Haribabu Kommi <kommi.haribabu@gmail.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Andrew Dunstan <andrew.dunstan@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default David Rowley <david.rowley@2ndquadrant.com>
Re: ALTER TABLE ADD COLUMN fast default Tom Lane <tgl@sss.pgh.pa.us>
Hi,

On 2018-02-20 20:57:36 +0100, Tomas Vondra wrote:
> The question is how should the schema for TPC-H look like. Because if
> you just do the usual test without any ALTER TABLE ADD COLUMN, then you
> really won't get any difference at all. The fast default stuff will be
> completely "inactive".

Well, there'll still be changed behaviour due to the changed sizes of
structures and new out of line function calls. The deforming code is
quite sensitive to such changes.

I think just verifying that there's no meaningful effect with/without
the patch is good enough. As soon as there's actual new columns that
take advantage of the new functionality I think some degradation is fair
game, you got some benefit for it.

Greetings,

Andres Freund

В списке pgsql-hackers по дате отправления
От: Brent Kerby
Дата:
От: Tom Lane
Дата:
FAQ