"Chris White \(cjwhite\)" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
