Re: cluster questions

From: Curt Sampson <cjs(at)cynic(dot)net>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: cluster questions
Date: 2003-02-24 00:53:00
Message-ID: Pine.NEB.4.51.0302240952470.659@angelic-vtfw.cvpn.cynic.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hadley Willan 2003-02-24 03:17:44 Why are absolute paths considered a security risk?
Previous Message Joe Tomcat 2003-02-23 21:36:03 Re: 7.4?