Re: Question about DB VACUUM

"Chris White \(cjwhite\)" <cjwhite(at)cisco(dot)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