Re: [PERFORM] Question about CLUSTER

2008-02-11 Thread Michael Fuhr
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 bette

Re: [PERFORM] Question about CLUSTER

2008-02-11 Thread Scott Marlowe
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 hig

[PERFORM] Question about CLUSTER

2008-02-11 Thread salman
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 assum