Re: how to change index cluster ratio?

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