CLUSTER command - Mailing list pgsql-general

From Jean-Luc Lachance
Subject CLUSTER command
Date
Msg-id 3DF90042.E5290B7F@nsd.ca
Whole thread Raw
In response to Docs: GIST  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Responses Re: CLUSTER command  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: CLUSTER command  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
List pgsql-general
Hi all,

I just read about the cluster command and was a little (very)
disapointed.
Clustered tables do not remain clustered after inserts.
Clustered tables are usefull when the table is very large and there are
few different keys.


Because the table file is already extended (2G limit) using different
files extension (.N)
how complicated (modifying the code) would it be to have the table files
split according to the cluster key?

This would:

Greatly improve performance when the cluster key in included in search
criteria.
Allow for a much larger table before a file has to be split (.N).
Simplify the management of symblinks (that's something else we need to
look at).
The index file for that field would no longer be required.

Of course, there should be only one cluster key per table.
The length the "key" should be short and the number of unique key should
be low as well.

SO... ?

JLL

pgsql-general by date:

Previous
From: Manfred Koizar
Date:
Subject: Re: PostgreSQL idocs
Next
From: Stephan Szabo
Date:
Subject: Re: problems updating table