The following bug has been logged online:
Bug reference: 4059
Logged by: Mark Steben
Email address: msteben(at)autorevenue(dot)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(at)postgresql(dot)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.