Re: Freeze avoidance of very large table.

Поиск
Список
Период
Сортировка
Искать
От
Robert Haas
Тема
Re: Freeze avoidance of very large table.
Дата
Msg-id
CA+TgmoYbrObSSzbvv66JttPP6LaQ7whQA=oAvcR35BNRxYnt2w@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Jeff Janes <jeff.janes@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. "ktm@rice.edu" <ktm@rice.edu>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Greg Stark <stark@mit.edu>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Petr Jelinek <petr@2ndquadrant.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Fujii Masao <masao.fujii@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Amit Kapila <amit.kapila16@gmail.com>
Re: Freeze avoidance of very large table. Amit Kapila <amit.kapila16@gmail.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Amit Kapila <amit.kapila16@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Fujii Masao <masao.fujii@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Masahiko Sawada <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Jeff Janes <jeff.janes@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Jeff Janes <jeff.janes@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Amit Kapila <amit.kapila16@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Amit Kapila <amit.kapila16@gmail.com>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Michael Paquier <michael.paquier@gmail.com>
Re: Freeze avoidance of very large table. Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Heikki Linnakangas <hlinnaka@iki.fi>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Heikki Linnakangas <hlinnaka@iki.fi>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Heikki Linnakangas <hlinnaka@iki.fi>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Heikki Linnakangas <hlinnaka@iki.fi>
Re: Freeze avoidance of very large table. Bruce Momjian <bruce@momjian.us>
Re: Freeze avoidance of very large table. Petr Jelinek <petr@2ndquadrant.com>
Re: Freeze avoidance of very large table. Heikki Linnakangas <hlinnaka@iki.fi>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Kevin Grittner <kgrittn@ymail.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Kevin Grittner <kgrittn@ymail.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Simon Riggs <simon@2ndQuadrant.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Michael Paquier <michael.paquier@gmail.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Freeze avoidance of very large table. Robert Haas <robertmhaas@gmail.com>
Re: Freeze avoidance of very large table. Jim Nasby <Jim.Nasby@BlueTreble.com>
Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
Re: Freeze avoidance of very large table. Sawada Masahiko <sawada.mshk@gmail.com>
Re: Freeze avoidance of very large table. Andres Freund <andres@anarazel.de>
On Tue, Mar 8, 2016 at 12:59 PM, Masahiko Sawada  wrote:
>> How about instead changing things so that we specifically reject
>> indexes?  And maybe some kind of a check that will reject anything
>> that lacks a relfilnode?  That seems like it would be more on point.
>
> I agree, I don't have strong opinion about this.
> It would be good to add condition for rejecting only indexes.
> Attached patches are,
>  - Change heap2 rmgr description
>  - Add condition to pg_visibility
>  - Fix typo in pgvisibility.sgml
> (Sorry for the late notice..)

OK, committed the first and last of those.  I think the other one
needs some work yet; the error message doesn't seem like it is quite
our usual style, and if we're going to do something here we should
probably also insert a check to throw a better error when there is no
relfilenode.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-hackers по дате отправления
От: Shulgin, Oleksandr
Дата:
От: Konstantin Knizhnik
Дата:
Сообщение: Re: Optimizer questions
FAQ