Re: questions about CLUSTER - Mailing list pgsql-performance

From Douglas J Hunley
Subject Re: questions about CLUSTER
Date
Msg-id 200802271345.11897.doug@hunley.homeip.net
Whole thread Raw
In response to Re: questions about CLUSTER  (Douglas J Hunley <doug@hunley.homeip.net>)
Responses Re: questions about CLUSTER  (Bill Moran <wmoran@collaborativefusion.com>)
List pgsql-performance
On Wednesday 27 February 2008 13:35:16 Douglas J Hunley wrote:
> > > 2) is there any internal data in the db that would allow me to
> > > programmatically determine which tables would benefit from being
> > > clustered? 3) for that matter, is there info to allow me to determine
> > > which index it should be clustered on in cases where the table has more
> > > than one index?
> >
> > The pg_stat_user_indexes table keeps stats on how often the index is
> > used. Indexes that are used frequently are candidates for clustering.
>
> I had just started looking at this actually.

ok, so for a follow-on, should I be more concerned with idx_scan,
idx_tup_read, or idx_tup_fetch when determining which indexes are 'good'
candidates?

again, tia. i feel like such a noob around here :)

--
Douglas J Hunley (doug at hunley.homeip.net) - Linux User #174778
http://doug.hunley.homeip.net

<kwall> I don't get paid. I just get a tip as the money passes through my
hands on its way from my employer to my debtors.

pgsql-performance by date:

Previous
From: Douglas J Hunley
Date:
Subject: Re: questions about CLUSTER
Next
From: Jeff Davis
Date:
Subject: Re: disabling an index without deleting it?