Postgres Pro
Downloads
Home   >   mailing lists

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

From Amit Langote
Subject Re: ALTER tbl rewrite loses CLUSTER ON index
Date
Msg-id CA+HiwqGLdpjUzqkP9XcdKcBYgdonVPVNdys76jyhR5qG3GtHHA@mail.gmail.com
Whole thread Raw
In response to Re: ALTER tbl rewrite loses CLUSTER ON index  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Kyotaro Horiguchi
Date:
Subject: Re: Tid scan increments value of pg_stat_all_tables.seq_scan. (butnot seq_tup_read)
Next
From: Antonin Houska
Date:
Subject: Re: Assumptions about the number of parallel workers