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

From huaxin zhang
Subject how to change index cluster ratio?
Date
Msg-id f2f562510509061157484ea352@mail.gmail.com
Whole thread Raw
In response to Re: statistics not shown up  (Michael Fuhr <mike@fuhr.org>)
Responses Re: how to change index cluster ratio?  (Tom Lane <tgl@sss.pgh.pa.us>)
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?