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
|