Question about CLUSTER

From: salman <salmanb(at)quietcaresystems(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Question about CLUSTER
Date: 2008-02-11 17:40:45
Message-ID: 47B0889D.9070609@quietcaresystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Can anyone point me to docs which explain this better?

-salman

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2008-02-11 18:15:40 oids
Previous Message Tom Lane 2008-02-11 17:29:14 Re: ERROR: expected just one rule action