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

Re: best way to choose index to cluster on?

From: adey <adey11(at)gmail(dot)com>
To: "Chris Hoover" <revoohc(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: best way to choose index to cluster on?
Date: 2006-09-25 22:27:03
Message-ID: 1c66bda80609251527i4e8bad89jb6c1420cd44a8a33@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
A good guide for a clustered index is:-
Will the index be unique, static and narrow.
If not, avoid clustered indexing as they require extra work on disk to
maintain their sequence.


On 9/26/06, Chris Hoover <revoohc(at)gmail(dot)com> wrote:
>
> I am looking to squeeze a bit more speed out of my database by clustering
> most of my tables.  However, on tables with multiple indexes, how is the
> best way to choose the index.  I am thinking I want to use the index with
> the largest pg_stat_user_indexes.idx_tup_read.  Would this be correct?  If
> not, what column(s) and views should I be looking at to find the most
> popular index?
>
> Secondly, I have some partial indexes on a very active table, and it tends
> to have the highest idx_tup_read for that table.  Is is possible to cluster
> on a partial index?
>
> Thanks,
>
> Chris
>

In response to

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2006-09-25 22:31:44
Subject: Re: best way to choose index to cluster on?
Previous:From: August ZajoncDate: 2006-09-25 21:57:04
Subject: Re: The server lacks instrumentation functions

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