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
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 |
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) |
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 |