Horton

Re: CLUSTER command

Stephan Szabo <sszabo@megazone23.bigpanda.com>

View thread View on postgr.es
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: <pgsql-general@postgresql.org>, <pgsql-performance@postgresql.org>
Date: 2002-12-12T22:27:02Z
Lists: pgsql-performance, pgsql-general 
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.