Postgres Pro
Downloads
Home   >   mailing lists

Re: What to vacuum after deleting lots of tables - Mailing list pgsql-performance

From Tom Lane
Subject Re: What to vacuum after deleting lots of tables
Date
Msg-id 18593.1189484591@sss.pgh.pa.us
Whole thread Raw
In response to What to vacuum after deleting lots of tables  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: What to vacuum after deleting lots of tables
Next
From: Ruben Rubio
Date:
Subject: [Again] Postgres performance problem