Re: [PERFORM] CLUSTER command

From: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To: pgsql-general(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] CLUSTER command
Date: 2002-12-12 21:40:24
Message-ID: 3DF90248.9BAF931C@nsd.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-interfaces pgsql-performance

Oh, and something else,

I think the syntax should be:

Cluster <table> on <attribute>

Maybe inheritance can be use here.
The problem is creating the new "table" when a new key is detected.
I know, I can use rules, but the optimiser is not aware of the
clustering.

Enough from me for now.

What do you think?

JLL

Jean-Luc Lachance wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Aravind Vinnakota 2002-12-12 21:41:02 client for solaris
Previous Message Stephan Szabo 2002-12-12 21:36:16 Re: problems updating table

Browse pgsql-interfaces by date

  From Date Subject
Next Message Stephan Szabo 2002-12-12 22:03:56 Re: CLUSTER command
Previous Message Jean-Luc Lachance 2002-12-12 21:31:46 CLUSTER command

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2002-12-12 22:03:56 Re: CLUSTER command
Previous Message Jean-Luc Lachance 2002-12-12 21:31:46 CLUSTER command