Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-novicepgsql-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

pgsql-novice by date

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

pgsql-performance by date

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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group