Re: ALTER tbl rewrite loses CLUSTER ON index - Mailing list pgsql-hackers

From Justin Pryzby
Subject Re: ALTER tbl rewrite loses CLUSTER ON index
Date
Msg-id 20200316132731.GJ26184@telsasoft.com
Whole thread Raw
In response to Re: ALTER tbl rewrite loses CLUSTER ON index  (Amit Langote <amitlangote09@gmail.com>)
Responses Re: ALTER tbl rewrite loses CLUSTER ON index  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
On Mon, Mar 16, 2020 at 04:01:42PM +0900, Amit Langote wrote:
> I came across a commit that recently went in:
> 
> commit 1cc9c2412cc9a2fbe6a381170097d315fd40ccca
> Author: Peter Eisentraut <peter@eisentraut.org>
> Date:   Fri Mar 13 11:28:11 2020 +0100
> 
>     Preserve replica identity index across ALTER TABLE rewrite
> 
> which fixes something very similar to what we are trying to with this
> patch.  The way it's done looks to me very close to what you are
> telling.  I have updated the patch to be similar to the above fix.

Yes, I noticed it too.

Should we use your get_index_isclustered more widely ?

Also, should we call it "is_index_clustered", since otherwise it sounds alot
like "+get_index_clustered" (without "is"), which sounds like it takes a table
and returns which index is clustered.  That might be just as useful for some of
these callers.

-- 
Justin

Attachment

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: Libpq support to connect to standby server as priority
Next
From: David Steele
Date:
Subject: Re: VACUUM memory management