Group: pgsql.performance


Subject: What to vacuum after deleting lots of tables
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 9/11/2007 12:23:11 AM
Craig James <craig_james@emolecules.com> writes: > If I delete a whole bunch of tables (like 10,000 tables), should I vacuum system tables, and if so, which ones? (This system is still on 8.1.4 and isn't running autovacuum). "All of them" would do for a first approximation. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org