Re: [PERFORM] Question about CLUSTER

On Feb 11, 2008 2:03 PM, salman [EMAIL PROTECTED] wrote: Hello, I'm planning to cluster a few large tables in our database but I'm unable to find any recommendations/documentation on best practices -- Mainly, whether it's better to use an index which has a higher idx_scan value, a higher

[PERFORM] Question about CLUSTER

Hello, I'm planning to cluster a few large tables in our database but I'm unable to find any recommendations/documentation on best practices -- Mainly, whether it's better to use an index which has a higher idx_scan value, a higher idx_tup_read value, or the higest idx_tup_fetch value. I'm

Re: [PERFORM] Question about CLUSTER

On Mon, Feb 11, 2008 at 03:33:37PM -0600, Scott Marlowe wrote: On Feb 11, 2008 2:03 PM, salman [EMAIL PROTECTED] wrote: I'm planning to cluster a few large tables in our database but I'm unable to find any recommendations/documentation on best practices -- Mainly, whether it's better to use