Thread: What to vacuum after deleting lots of tables

What to vacuum after deleting lots of tables

From
Craig James
Date:
If I delete a whole bunch of tables (like 10,000 tables), should I vacuum system tables, and if so, which ones?  (This
systemis still on 8.1.4 and isn't running autovacuum). 

Thanks,
Craig

Re: What to vacuum after deleting lots of tables

From
Tom Lane
Date:
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?
(Thissystem is still on 8.1.4 and isn't running autovacuum). 

"All of them" would do for a first approximation.

            regards, tom lane