Re: ALTER tbl rewrite loses CLUSTER ON index

From: Amit Langote <amitlangote09(at)gmail(dot)com>
To: Justin Pryzby <pryzby(at)telsasoft(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: ALTER tbl rewrite loses CLUSTER ON index
Date: 2020-02-06 09:14:16
Message-ID: CA+HiwqEt1HnXYckCdaO8+pOoFs7NNS5byoZ6Xg2B7epKbhS85w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Feb 6, 2020 at 10:31 AM Amit Langote <amitlangote09(at)gmail(dot)com> wrote:
> On Thu, Feb 6, 2020 at 8:44 AM Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
> > On Wed, Feb 05, 2020 at 03:53:45PM +0900, Amit Langote wrote:
> > > diff --git a/src/test/regress/sql/alter_table.sql b/src/test/regress/sql/alter_table.sql
> > > +-- alter type shouldn't lose clustered index
> >
> > My only suggestion is to update the comment
> > +-- alter type rewrite/rebuild should preserve cluster marking on index
>
> Sure, done.

Deja vu. Last two messages weren't sent to the list; updated patch attached.

Thanks,
Amit

Attachment Content-Type Size
preserve-CLUSTER-ON-during-ALTER-TABLE_v3.patch text/plain 5.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2020-02-06 09:21:17 Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions
Previous Message Amit Kapila 2020-02-06 09:10:29 replication_origin and replication_origin_lsn usage on subscriber