> Probably the indexes are bloated after the vacuum full. I think the > best way to get rid of the "fat" is to recreate both tables and indexes > anew. For this the best tool would be to CLUSTER the tables on some > index, probably the primary key. This will be much faster than > VACUUMing the tables, and the indexes will be much smaller as result.
I guess you're right. I forgot to mention there are 12 composed indexes on the largest (and not deleted) table B, having about 14.000.000 rows and 1 GB of data. I'll try to dump/reload the database ... t.v. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
