Re: Press Release Draft - 2016-02-09 Cumulative Update

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.

In response to

Browse pgsql-hackers by date

  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")