Postgres Pro
Downloads
Home   >   mailing lists

Re: why toast tables are not reindexed while clustering? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: why toast tables are not reindexed while clustering?
Date
Msg-id 814.1153714093@sss.pgh.pa.us
Whole thread Raw
In response to why toast tables are not reindexed while clustering?  (SAKATA Tetsuo <sakata.tetsuo@oss.ntt.co.jp>)
Responses Re: why toast tables are not reindexed while clustering?  (SAKATA Tetsuo <sakata.tetsuo@oss.ntt.co.jp>)
List pgsql-hackers
Tree view 
SAKATA Tetsuo <sakata.tetsuo@oss.ntt.co.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 ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Adding a pgbench run to buildfarm
Next
From: Mark Kirkwood
Date:
Subject: Re: Adding a pgbench run to buildfarm