Re: [HACKERS] REINDEX CONCURRENTLY 2.0

Поиск
Список
Период
Сортировка
Искать
От
Jim Nasby
Тема
Re: [HACKERS] REINDEX CONCURRENTLY 2.0
Дата
Msg-id
af867d20-1406-38c0-0a58-2cf1fce7240f@BlueTreble.com
Ответ на
Список
Дерево обсуждения
REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter_e@gmx.net>
Re: REINDEX CONCURRENTLY 2.0 Jim Nasby <jim@nasby.net>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: REINDEX CONCURRENTLY 2.0 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Jeff Janes <jeff.janes@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter_e@gmx.net>
Re: REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter_e@gmx.net>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Oskari Saarenmaa <os@ohmu.fi>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Jim Nasby <jim.nasby@openscg.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: REINDEX CONCURRENTLY 2.0 Michael Banck <michael.banck@credativ.de>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andrew Gierth <andrew@tao11.riddles.org.uk>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Vik Fearing <vik.fearing@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Vik Fearing <vik.fearing@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Pavel Stehule <pavel.stehule@gmail.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Stephen Frost <sfrost@snowman.net>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Banck <michael.banck@credativ.de>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Sergei Kornilov <sk@zsrv.org>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
RE: REINDEX CONCURRENTLY 2.0 "Shinoda, Noriyoshi (PN Japan A&PS Delivery)"<noriyoshi.shinoda@hpe.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Robert Treat <rob@xzilla.net>
Re: REINDEX CONCURRENTLY 2.0 Andres Freund <andres@anarazel.de>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 "Bossart, Nathan" <bossartn@amazon.com>
Re: REINDEX CONCURRENTLY 2.0 Justin Pryzby <pryzby@telsasoft.com>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: REINDEX CONCURRENTLY 2.0 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Andreas Karlsson <andreas@proxel.se>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Michael Paquier <michael@paquier.xyz>
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 Pavel Stehule <pavel.stehule@gmail.com>
On 2/28/17 11:21 AM, Andreas Karlsson wrote:
> The only downside I can see to this approach is that we no logner will
> able to reindex catalog tables concurrently, but in return it should be
> easier to confirm that this approach can be made work.

Another downside is any stored regclass fields will become invalid. 
Admittedly that's a pretty unusual use case, but it'd be nice if there 
was at least a way to let users fix things during the rename phase 
(perhaps via an event trigger).
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)


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