[PERFORM] What to vacuum after deleting lots of tables

2007-09-10 Thread Craig James
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). Thanks, Craig ---(end of broadcast)--- TIP 4: Have you searched our

Re: [PERFORM] What to vacuum after deleting lots of tables

2007-09-10 Thread Tom Lane
Craig James [EMAIL PROTECTED] 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.