From: | "Jonathan S(dot) Katz" <jkatz(at)postgresql(dot)org> |
---|---|
To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Press Release Draft - 2016-02-09 Cumulative Update |
Date: | 2017-02-08 01:52:56 |
Message-ID: | 2EA88903-3931-4092-BDED-4D3DF4846D8A@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> On Feb 7, 2017, at 6:40 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
>
> Jonathan S. Katz wrote:
>>
>>> On Feb 7, 2017, at 4:07 PM, Alvaro Herrera <alvherre(at)2ndquadrant(dot)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.
Cool. Updated:
https://git.postgresql.org/gitweb/?p=press.git;a=blob;f=update_releases/current/20170209updaterelease.txt;h=56551b56eb1f70e734c5762abf5ddf6bd6965fdb;hb=c1b7f9c0cfd0ff106409d14a36c3122a8ee460d0 <https://git.postgresql.org/gitweb/?p=press.git;a=blob;f=update_releases/current/20170209updaterelease.txt;h=56551b56eb1f70e734c5762abf5ddf6bd6965fdb;hb=c1b7f9c0cfd0ff106409d14a36c3122a8ee460d0>
I added a note to alert people to disk space usage utilizing this method.
Thanks for the help!
Jonathan.
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2017-02-08 02:37:30 | Re: Parallel bitmap heap scan |
Previous Message | Piotr Stefaniak | 2017-02-08 01:24:40 | pg_bsd_indent: implement -lps ("leave preprocessor space") |