Re: how to change index cluster ratio?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: huaxin zhang <uwcssa(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to change index cluster ratio?
Date: 2005-09-06 20:36:52
Message-ID: 20338.1126039012@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

huaxin zhang <uwcssa(at)gmail(dot)com> writes:
> One problem I found is that even if I specify to create a clustered index by
> "cluster idx_name on table_name", I still can not tell the optimizer that the
> index of "idx_name" is a clustered index with "index correlation" value as 1.0
> (traced from the cost_index() in costsize.c)

The next ANALYZE should figure that out.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2005-09-06 20:57:29 Re: Windows pgpass Problems..
Previous Message huaxin zhang 2005-09-06 18:57:46 how to change index cluster ratio?