On Feb 7, 2017, at 6:40 PM, Alvaro Herrera <alvherre@2ndquadrant.com> wrote:Jonathan S. Katz wrote:On Feb 7, 2017, at 4:07 PM, Alvaro Herrera <alvherre@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 youwith 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? ORDo the CREATE INDEX CONCURRENTLY first, then DROP INDEX CONCURRENTLY theold index, then rename the new index to the old name.
On Feb 7, 2017, at 4:07 PM, Alvaro Herrera <alvherre@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 youwith 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
On Feb 7, 2017, at 4:07 PM, Alvaro Herrera <alvherre@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 youwith a window where the affected columns are not indexed at all.
Thanks for the clarification. I have updated the recipe along with Emre’s comments here:[updated text not included in the email]
pgsql-hackers by date:
Соглашаюсь с условиями обработки персональных данных