Re: Vacuum issues..

["Matthew T. O'Connor" <matthew@xxxxxxxx>]

Eamonn Kent wrote:
> I am using PostgreSQL 8.1.4 for an embedded application.  For some 
> reason, vacuum is not able to identify rows that are candidates for 
> removal (i.e., mark space as available).
[snip]
> If I shutdown our application and run a vacuum full, the space is 
> recovered and the database size goes down to 150M. 

The most common answer to this is that your application is leaving open 
transactions just sitting there.  VACUUM can't remove tuples that may 
still need to be visible to a transaction that's been open for days.