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

From Stephan Szabo
Subject Re: [GENERAL] CLUSTER command
Date
Msg-id 20021212142547.J12742-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: [GENERAL] CLUSTER command  (Jean-Luc Lachance <jllachan@nsd.ca>)
List pgsql-performance
On Thu, 12 Dec 2002, Jean-Luc Lachance wrote:

> The current cluster command is equivalant to:
>
> create b as select * from a order by i;
>
> So you would not be loosing anything.

Except for the fact that the CLUSTER is intended (although
I don't know if it does yet) to retain things like constraints
and other indexes which the above doesn't.


pgsql-performance by date:

Previous
From: johnnnnnn
Date:
Subject: Re: [GENERAL] CLUSTER command
Next
From: Lincoln Yeoh
Date:
Subject: Re: [GENERAL] CLUSTER command