Re: [HACKERS] REINDEX CONCURRENTLY 2.0
От | Andres Freund |
---|---|
Тема | Re: [HACKERS] REINDEX CONCURRENTLY 2.0 |
Дата | |
Msg-id | 20170302061808.nfuptpli3lrlc5l7@alap3.anarazel.de обсуждение исходный текст |
Ответ на | Re: [HACKERS] REINDEX CONCURRENTLY 2.0 (Jim Nasby <Jim.Nasby@BlueTreble.com>) |
Ответы |
Re: [HACKERS] REINDEX CONCURRENTLY 2.0
|
Список | 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
В списке pgsql-hackers по дате отправления: