Re: REINDEX CONCURRENTLY 2.0
От
Sergei Kornilov
Тема
Re: REINDEX CONCURRENTLY 2.0
Дата
Msg-id
154954968565.11785.6973123402105637191.pgcf@coridan.postgresql.org
Ответ на
Re: [HACKERS] REINDEX CONCURRENTLY 2.0 (Peter Eisentraut)
Список
Дерево обсуждения
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>
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: not tested Documentation: tested, passed Hello Sorry for late response. I review latest patch version. I didn't found any new behavior bugs. reindex concurrenlty can be in deadlock with another reindex concurrently (or manual vacuum (maybe with wraparound autovacuum) or create index concurrently on same table). But i think this is not issue for this feature, two create index concurrently can be in deadlock too. Just one small note for documentation: > +Indexes: > + "idx" btree (col) > + "idx_cct" btree (col) INVALID Second index should be idx_ccnew (or idx_ccold), right? Code looks good for me. regards, Sergei
В списке pgsql-hackers по дате отправления
От: Daniel Gustafsson
Дата: