Horton

Re: cluster questions

Curt Sampson <cjs@cynic.net>

View thread View on postgr.es
From: Curt Sampson <cjs@cynic.net>
To: Greg Stark <gsstark@mit.edu>
Cc: pgsql-general@postgresql.org
Date: 2003-02-24T00:53:00Z
Lists: 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