| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Luc Lachance | 2002-12-12 22:39:44 | Re: [PERFORM] CLUSTER command |
| Previous Message | johnnnnnn | 2002-12-12 22:26:41 | Re: [GENERAL] CLUSTER command |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Luc Lachance | 2002-12-12 22:39:44 | Re: [PERFORM] CLUSTER command |
| Previous Message | johnnnnnn | 2002-12-12 22:26:41 | Re: [GENERAL] CLUSTER command |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jean-Luc Lachance | 2002-12-12 22:39:44 | Re: [PERFORM] CLUSTER command |
| Previous Message | johnnnnnn | 2002-12-12 22:26:41 | Re: [GENERAL] CLUSTER command |