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

Re: [GENERAL] CLUSTER command

From: johnnnnnn <john(at)phaedrusdeinus(dot)org>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] CLUSTER command
Date: 2002-12-12 22:26:41
Message-ID: 20021212222641.GA8278@performics.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-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

In response to

Responses

pgsql-performance by date

Next:From: Stephan SzaboDate: 2002-12-12 22:27:02
Subject: Re: CLUSTER command
Previous:From: Jean-Luc LachanceDate: 2002-12-12 22:15:37
Subject: Re: CLUSTER command

pgsql-interfaces by date

Next:From: Stephan SzaboDate: 2002-12-12 22:27:02
Subject: Re: CLUSTER command
Previous:From: Jean-Luc LachanceDate: 2002-12-12 22:15:37
Subject: Re: CLUSTER command

pgsql-general by date

Next:From: Stephan SzaboDate: 2002-12-12 22:27:02
Subject: Re: CLUSTER command
Previous:From: Jean-Luc LachanceDate: 2002-12-12 22:15:37
Subject: Re: CLUSTER command

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