cluster questions

From: Greg Stark <gsstark(at)mit(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: cluster questions
Date: 2003-02-21 17:48:04
Message-ID: 87isvdzfsb.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Mascari 2003-02-21 18:03:46 HAVING and column alias
Previous Message elein 2003-02-21 17:45:05 Non-English lists and User Groups