pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mathijs Brands <mathijs@ilse.nl>
To: Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Justin Long <justinlong@strategicnetwork.org>
Cc: pgsql-sql@postgresql.org
Subject: Clustering (was Re: Optimizing Query)
Date: Mon, 5 Mar 2001 23:03:56 +0100
Message-ID: <20010305230355.B22983@ilse.nl> (raw)
In-Reply-To: <200103052145.QAA04808@candle.pha.pa.us>
References: <20010305224029.A22983@ilse.nl>
	<200103052145.QAA04808@candle.pha.pa.us>

On Mon, Mar 05, 2001 at 04:45:47PM -0500, Bruce Momjian allegedly wrote:
> Yes.
> 
> > On Mon, Mar 05, 2001 at 04:07:57PM -0500, Bruce Momjian allegedly wrote:
> > > Have you tried VACUUM ANALYZE and CLUSTER?
> > 
> > I assume CLUSTER still drops all indexes except the one you're clustering
> > on?
> > 
> > Mathijs

So running cluster on the words table (which is indexed with a seperate index
on each of the two fields) would probably decrease performance by getting rid
of one index without warning (the one NOT specified in the cluster command)?

How useful is clustering with pgsql when in a lot of situations systems have
enough memory to have the filesystem subsystem cache most or all index data?
Seek times shouldn't be an issue in such a situation, since the index doesn't
have to be read.

Just wondering,

Mathijs
-- 
It's not that perl programmers are idiots, it's that the language
rewards idiotic behavior in a way that no other language or tool has
ever done.
                                                    Erik Naggum



Message-ID: <20010305230355.B22983@ilse.nl>
Permalink:  ../20010305230355.B22983@ilse.nl/
Also on:    postgresql.org/message-id/20010305230355.B22983@ilse.nl

 · 

reply

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-sql@postgresql.org
  Cc: mathijs@ilse.nl, pgman@candle.pha.pa.us, justinlong@strategicnetwork.org
  Subject: Re: Clustering (was Re: Optimizing Query)
  In-Reply-To: <20010305230355.B22983@ilse.nl>
  References: <20010305224029.A22983@ilse.nl> <200103052145.QAA04808@candle.pha.pa.us> <20010305230355.B22983@ilse.nl>

* 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