cluster questions
Started by Bruce Momjianabout 23 years ago2 messagesgeneral
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? Is that effectively
the same as a vacuum full as far as the resulting space usage?
In 7.4 does the new cluster support change this?
--
greg
Re: cluster questions
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