Re: why toast tables are not reindexed while clustering?

From: SAKATA Tetsuo <sakata(dot)tetsuo(at)oss(dot)ntt(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: why toast tables are not reindexed while clustering?
Date: 2006-07-25 10:09:03
Message-ID: 44C5EDBF.9040309@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Thank you for your quick answering my question. > Tom.

Tom Lane wrote:
> SAKATA Tetsuo <sakata(dot)tetsuo(at)oss(dot)ntt(dot)co(dot)jp> writes:
>> I'll be pleased if someone tell me the reason why
>> when a table is clustered the toast table is not reindexed.
>
> It's not obvious that those two things should be related. You can
> reindex the toast table if you wish ...

I have some thoughts.

(1) If there are no significant reason why two things are related,
we should reindex toast table while clustering.
( I searched PostgreSQL mailing list archive about this topic,
only to fail finding significant discussion.)

(2) If some reasons exist and it is not appropriate to reindex toast table,
we describe it in the PostgreSQL documentation.

(3) And then, giving some way to users that they create index(es)
only on the toast table. Now, when we reindex the table after clustering it,
we create all index(es) on the table that we cluster.
So we create the same index(es) twice.

best regards,

Tetsuo.
--
sakata.tetsuo _at_ oss.ntt.co.jp
SAKATA, Tetsuo. Shinagawa Tokyo JAPAN.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2006-07-25 11:00:24 Re: root/administartor user check option.
Previous Message Gevik Babakhani 2006-07-25 10:01:41 root/administartor user check option.