From: Douglas J Hunley <doug@hunley.homeip.net>
To: Bill Moran <wmoran@collaborativefusion.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: questions about CLUSTER
Date: Wed, 27 Feb 2008 13:45:11 -0500
Message-ID: <200802271345.11897.doug@hunley.homeip.net> (raw)
In-Reply-To: <200802271335.16397.doug@hunley.homeip.net>
References: <200802271101.57169.doug@hunley.homeip.net>
<20080227124057.9b3937ce.wmoran@collaborativefusion.com>
<200802271335.16397.doug@hunley.homeip.net>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: doug@hunley.homeip.net, wmoran@collaborativefusion.com
Subject: Re: questions about CLUSTER
In-Reply-To: <200802271345.11897.doug@hunley.homeip.net>
References: <200802271101.57169.doug@hunley.homeip.net> <20080227124057.9b3937ce.wmoran@collaborativefusion.com> <200802271335.16397.doug@hunley.homeip.net> <200802271345.11897.doug@hunley.homeip.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox