Jonathan S. Katz wrote: > > > On Feb 7, 2017, at 4:07 PM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > > > > Jonathan S. Katz wrote: > > > >> Thanks for the clarification. I have updated the recipe along with Emre’s > >> comments here: > >> > >> [updated text not included in the email] > > > > I still don't think the recipe is a very good one because it leaves you > > with a window where the affected columns are not indexed at all. > > Okay, so I propose two options: > > 1. Does anyone have a recipe they recommend that might be better? OR
Do the CREATE INDEX CONCURRENTLY first, then DROP INDEX CONCURRENTLY the old index, then rename the new index to the old name. -- Álvaro Herrera https://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers