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

From huaxin zhang
Subject how to change index cluster ratio?
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: statistics not shown up  (Michael Fuhr <[email protected]>)
Responses Re: how to change index cluster ratio?
List pgsql-admin
I am using 8.0.3

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)

so where is the "index correlation" information stored and how can i update it?

thanks
Huaxin

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Windows pgpass Problems..
Next
From: Tom Lane
Date:
Subject: Re: how to change index cluster ratio?