Re: Question about DB VACUUM

"Chris White \(cjwhite\)" <cjwhite@cisco.com> writes:
> But as you could see from the prior query \lo_list showed no large
> objects, this was done just prior to the vacuum.

> aesop=# \lo_list
>   Large objects
>  ID | Description
> ----+-------------
> (0 rows)

> aesop=# vacuum verbose pg_largeobject;
> NOTICE:  --Relation pg_largeobject--
> NOTICE:  Index pg_largeobject_loid_pn_index: Pages 2819; Tuples 460:
> Deleted 84.

This would seem to indicate that you have open transactions hanging
around somewhere in the background.  VACUUM can't delete tuples that
might still be visible under MVCC rules to some open transaction.

            regards, tom lane