Re: ALTER tbl rewrite loses CLUSTER ON index

Amit Langote <amitlangote09@gmail.com>

From: Amit Langote <amitlangote09@gmail.com>

To: Alvaro Herrera <alvherre@2ndquadrant.com>

Cc: Justin Pryzby <pryzby@telsasoft.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2020-02-07T08:42:36Z

Lists: pgsql-hackers

On Fri, Feb 7, 2020 at 2:24 AM Alvaro Herrera <alvherre@2ndquadrant.com> wrote:
> On 2020-Feb-06, Justin Pryzby wrote:
> > I wondered if it wouldn't be better if CLUSTER ON was stored in pg_class as the
> > Oid of a clustered index, rather than a boolean in pg_index.
>
> Maybe.  Do you want to try a patch?

+1

Thanksm
Amit

Commits

Refactor cluster.c to use new routine get_index_isclustered()
- 8ef9451f58ee 13.0 landed
Preserve clustered index after rewrites with ALTER TABLE
- 3f77a670241d 9.5.22 landed
- 61a161fe4421 9.6.18 landed
- cef2b8d52c59 10.13 landed
- 41faafbd75a5 11.8 landed
- 3e62dd3a937b 12.3 landed
- a40caf5f862c 13.0 landed
Preserve replica identity index across ALTER TABLE rewrite
- 1cc9c2412cc9 13.0 cited
Remove RangeIOData->typiofunc
- a77315fdf2a1 13.0 cited
Preserve pg_index.indisclustered across REINDEX CONCURRENTLY
- f087d63a45b5 12.3 landed
- d79fb88ac738 13.0 landed