Question about CLUSTER - Mailing list pgsql-admin

From salman
Subject Question about CLUSTER
Date
Msg-id 47B0AA1F.8040101@quietcaresystems.com
Whole thread Raw
Responses Re: [PERFORM] Question about CLUSTER  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-admin
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 assuming that idx_tup_read would probably be the best choice, but
want to get other opinions before proceeding.

Can anyone point me to docs which explain this better?

-salman



pgsql-admin by date:

Previous
From: Chander Ganesan
Date:
Subject: Re: 8.3.0 upgrade, confused by documentation
Next
From: "Tena Sakai"
Date:
Subject: Re: 8.3.0 upgrade, confused by documentation