Re: why toast tables are not reindexed while clustering?

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

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

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2006-07-24 04:24:50 Re: Adding a pgbench run to buildfarm
Previous Message Tom Lane 2006-07-24 04:06:30 Re: Adding a pgbench run to buildfarm