"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