Re: What to vacuum after deleting lots of tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Craig James <craig_james(at)emolecules(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What to vacuum after deleting lots of tables
Date: 2007-09-11 04:23:11
Message-ID: 18593.1189484591@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Craig James <craig_james(at)emolecules(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Ruben Rubio 2007-09-11 06:33:47 [Again] Postgres performance problem
Previous Message Craig James 2007-09-11 04:12:10 What to vacuum after deleting lots of tables