cluster questions - Mailing list pgsql-general

From Greg Stark
Subject cluster questions
Date
Msg-id 87isvdzfsb.fsf@stark.dyndns.tv
Whole thread Raw
Responses Re: cluster questions
List 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

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Foreign Key with Constant
Next
From: elein
Date:
Subject: Non-English lists and User Groups