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

Re: CLUSTER command

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
Cc: <pgsql-general(at)postgresql(dot)org>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: CLUSTER command
Date: 2002-12-12 22:27:02
Message-ID: 20021212142547.J12742-100000@megazone23.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-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.


In response to

pgsql-performance by date

Next:From: Jean-Luc LachanceDate: 2002-12-12 22:39:44
Subject: Re: [PERFORM] CLUSTER command
Previous:From: johnnnnnnDate: 2002-12-12 22:26:41
Subject: Re: [GENERAL] CLUSTER command

pgsql-interfaces by date

Next:From: Jean-Luc LachanceDate: 2002-12-12 22:39:44
Subject: Re: [PERFORM] CLUSTER command
Previous:From: johnnnnnnDate: 2002-12-12 22:26:41
Subject: Re: [GENERAL] CLUSTER command

pgsql-general by date

Next:From: Jean-Luc LachanceDate: 2002-12-12 22:39:44
Subject: Re: [PERFORM] CLUSTER command
Previous:From: johnnnnnnDate: 2002-12-12 22:26:41
Subject: Re: [GENERAL] CLUSTER command

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