Re: how to change index cluster ratio?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



huaxin zhang <uwcssa@xxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux