Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Sullivan
Subject Re: Does VACUUM reorder tables on clustered indices
Date
Msg-id 20051219132524.GA6777@phlogiston.dyndns.org
Whole thread Raw
In response to Re: Does VACUUM reorder tables on clustered indices  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Does VACUUM reorder tables on clustered indices
List pgsql-sql
Tree view 
On Sun, Dec 18, 2005 at 10:08:22PM -0500, Tom Lane wrote:
> 
> Just for the record, that behavior is seriously broken: it violates
> MVCC if any of the deleted tuples are still visible to anyone else.

Does it remove tuples that VACUUM FULL wouldn't?  I always thought it
did essentially the same thing?

A

-- 
Andrew Sullivan  | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what 
you told them to.  That actually seems sort of quaint now.    --J.D. Baldwin

pgsql-sql by date:

Previous
From: "Lane Van Ingen"
Date:
Subject: How to Force Transactions to Process Serially on A Table
Next
From: Achilleus Mantzios
Date:
Subject: Re: How to Force Transactions to Process Serially on A Table