"Gregory Maxwell" <gmaxwell@xxxxxxxxx> writes: > When I vacuum fulled nothing else was connected.. I just restarted PG > and vacuumed again.. no obvious change of disk size (still.. 6.4 > gigs).. but this changed: > amarokcollection=# select relname, pg_relation_size(oid) FROM > pg_class ORDER BY 2 DESC LIMIT 20; > relname | pg_relation_size > ---------------------------------+------------------ > pg_attribute_relid_attnam_index | 2881069056 > pg_class_relname_nsp_index | 1185890304 That's in a different database --- evidently, the one where a *whole* lotta temp tables have been created and dropped. If you haven't been doing any vacuuming then system catalog bloat is to be expected. regards, tom lane
