Re: Question about DB VACUUM

"Chris White \(cjwhite\)" <cjwhite@cisco.com> writes:
> Why aren't there any unused tuples?

The "unused" number isn't especially interesting, it's just the number
of line pointer slots that were once used and aren't at the moment.
At 4 bytes apiece, they aren't costing you anything worth noticing.

> Why is the pg_largeobject_loid_pn_index table so big (2818 pages)?

This looks like a standard "index bloat" problem (see the archives
for details).  "REINDEX pg_largeobject" would make the bloat go away
for awhile.  7.4 should largely solve this problem, but in earlier
releases you need to figure on periodic reindexing.

> Why has table grown by 4 pages.

Probably because there are now 460 live tuples instead of 227.
I don't think you've entirely fixed your problem of not removing
all unused large objects...

            regards, tom lane