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 20200206144426.GH403@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
List pgsql-hackers
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.

That likely would've avoided (or at least exposed) this issue.
And avoids the possibility of having two indices marked as "clustered".
These would be more trivial:
mark_index_clustered
/* We need to find the index that has indisclustered set. */



pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: bad logging around broken restore_command
Next
From: Alvaro Herrera
Date:
Subject: Re: Do not check unlogged indexes on standby