Re: [GENERAL] CLUSTER command - Mailing list pgsql-performance

From johnnnnnn
Subject Re: [GENERAL] CLUSTER command
Date
Msg-id 20021212222641.GA8278@performics.com
Whole thread Raw
In response to Re: [GENERAL] CLUSTER command  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-performance
On Thu, Dec 12, 2002 at 02:03:56PM -0800, Stephan Szabo wrote:
> I'd vote against changing the existing CLUSTER since the existing
> CLUSTER while not great does handle many different key values fairly
> well as well and this solution wouldn't.

I would agree. What's being proposed sounds much more like table
partitioning than clustering.

That's not to say that the existing CLUSTER couldn't be improved, at
the very least to the point where it allows inserts to respect the
clustered structure. That's a post for another thread, though.

-johnnnnnnnnnnn

pgsql-performance by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: [GENERAL] CLUSTER command
Next
From: Stephan Szabo
Date:
Subject: Re: [GENERAL] CLUSTER command