Postgres Pro
Downloads
Home   >   mailing lists

Re: how to change index cluster ratio? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to change index cluster ratio?
Date
Msg-id 20338.1126039012@sss.pgh.pa.us
Whole thread Raw
In response to how to change index cluster ratio?  (huaxin zhang <uwcssa@gmail.com>)
List pgsql-admin
Tree view 
huaxin zhang <uwcssa@gmail.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

pgsql-admin by date:

Previous
From: huaxin zhang
Date:
Subject: how to change index cluster ratio?
Next
From: Scott Marlowe
Date:
Subject: Re: Windows pgpass Problems..