Re: REINDEX CONCURRENTLY 2.0
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: Jim Nasby <Jim.Nasby@BlueTreble.com>
Cc: Andreas Karlsson <andreas@proxel.se>, Michael Paquier <michael.paquier@gmail.com>, PostgreSQL mailing lists <pgsql-hackers@postgresql.org>
Date: 2017-03-02T06:18:08Z
Lists: pgsql-hackers
On 2017-03-01 19:25:23 -0600, Jim Nasby wrote: > 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). I'm fairly confident that we don't want to invoke event triggers inside the CIC code... I'm also fairly confident that between index oids stored somewhere being invalidated - what'd be a realistic use case of that - and not having reindex concurrently, just about everyone will choose the former. Regards, Andres
Commits
-
Prevent reindex of invalid indexes on TOAST tables
- 8bca5f93547c 12.3 landed
- 61d7c7bce368 13.0 landed
-
Rework handling of invalid indexes with REINDEX CONCURRENTLY
- a6dcf9df4d91 12.0 landed
-
Split builtins.h to a new header ruleutils.h
- 7b1c2a0f2066 9.5.0 cited