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.
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. |