Thread

1. cluster questions

   Greg Stark <gsstark@mit.edu> — 2003-02-21T17:48:04Z

   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
   
   
   

2. Re: cluster questions

   Curt Sampson <cjs@cynic.net> — 2003-02-24T00:53:00Z

   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