Postgres Pro
Downloads
Home   >   mailing lists

BUG #4059: Vacuum full not always cleaning empty tables - Mailing list pgsql-bugs

From Mark Steben
Subject BUG #4059: Vacuum full not always cleaning empty tables
Date
Msg-id 200803252113.m2PLDWKd064175@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4059: Vacuum full not always cleaning empty tables
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      4059
Logged by:          Mark Steben
Email address:      msteben@autorevenue.com
PostgreSQL version: 8.2.5
Operating system:   Linux redhat
Description:        Vacuum full not always cleaning empty tables
Details:

I sent an email to 'pgsql-bugs@postgresql.org' entitled
 'Possible bug with VACUUM FULL' and also an addendum
But neglected to also send this bug report form.
You can refer to those emails; in a nutshell, I have found that VACUUM FULL
will not clean dead tuples out of an empty table when other queries are
accessing the database. Test plans/scenarios are included.

pgsql-bugs by date:

Previous
From: "David Rowley"
Date:
Subject: Re: Possible problem with EXTRACT(EPOCH FROM TIMESTAMP)
Next
From: "Bruce Nairn"
Date:
Subject: BUG #4060: libpq - large stack causes TCP/IP error