Joseph S <jks@xxxxxxxxxxxxxxx> writes: > Me too. I don't change my db schema that much, but I experience bloat > in the pg_tables that I don't expect. For instance pg_opclass needs a > VACUUM FULL/REINDEX once a week or I notice the indexes are larger than > the table itself. Could it be my heavy use of temp tables? pg_opclass? That's read-only for most people. What are you doing with operator classes? Heavy use of temp tables would expand pg_class, pg_type, and especially pg_attribute, but as long as you have a decent vacuuming regimen (do you use autovac?) they shouldn't get out of hand. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
