Re: cluster questions - Mailing list pgsql-general

From Curt Sampson
Subject Re: cluster questions
Date
Msg-id Pine.NEB.4.51.0302240952470.659@angelic-vtfw.cvpn.cynic.net
Whole thread Raw
In response to cluster questions  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
On Sat, 21 Feb 2003, Greg Stark wrote:

> Cluster has to sort the whole table (or do an index scan) and reorganize the
> data in the table. Does it do this by copying the data?

Yes,.

> Is that effectively
> the same as a vacuum full as far as the resulting space usage?

Yes.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC

pgsql-general by date:

Previous
From: _
Date:
Subject: ignore previous message NOTICE: Could not select primary index key
Next
From: Hadley Willan
Date:
Subject: Why are absolute paths considered a security risk?