Question about CLUSTER

From: salman <salmanb(at)quietcaresystems(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Question about CLUSTER
Date: 2008-02-11 20:03:43
Message-ID: 47B0AA1F.8040101@quietcaresystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-novice pgsql-performance

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tena Sakai 2008-02-11 20:15:14 Re: 8.3.0 upgrade, confused by documentation
Previous Message Chander Ganesan 2008-02-11 19:47:06 Re: 8.3.0 upgrade, confused by documentation

Browse pgsql-novice by date

  From Date Subject
Next Message Scott Marlowe 2008-02-11 21:33:37 Re: [PERFORM] Question about CLUSTER
Previous Message Tom Lane 2008-02-11 19:32:04 Re: Memory-leak-like effect on insane query (postgres 8.1.6)

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2008-02-11 21:29:40 Re: Update with Subquery Performance
Previous Message Thomas Zaksek 2008-02-11 18:08:25 Join Query Perfomance Issue