Postgres Pro
Downloads
Home   >   mailing lists

Re: Does VACUUM reorder tables on clustered indices - Mailing list pgsql-sql

From Tom Lane
Subject Re: Does VACUUM reorder tables on clustered indices
Date
Msg-id 13769.1134961702@sss.pgh.pa.us
Whole thread Raw
In response to Re: Does VACUUM reorder tables on clustered indices  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Does VACUUM reorder tables on clustered indices
Re: Does VACUUM reorder tables on clustered indices
List pgsql-sql
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Note that while reordering, CLUSTER also gets rid of dead tuples, so if
> you cluster you don't need to vacuum.

Just for the record, that behavior is seriously broken: it violates
MVCC if any of the deleted tuples are still visible to anyone else.
        regards, tom lane

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Need SQL Help Finding Current Status of members
Next
From: Alvaro Herrera
Date:
Subject: Re: Does VACUUM reorder tables on clustered indices