Re: Freeze avoidance of very large table.
От
Robert Haas
Тема
Re: Freeze avoidance of very large table.
Дата
Msg-id
CA+TgmoYbrObSSzbvv66JttPP6LaQ7whQA=oAvcR35BNRxYnt2w@mail.gmail.com
Ответ на
Re: Freeze avoidance of very large table. (Masahiko Sawada)
Список
Дерево обсуждения
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
Дата: