What to vacuum after deleting lots of tables

From: Craig James <craig_james(at)emolecules(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: What to vacuum after deleting lots of tables
Date: 2007-09-11 04:12:10
Message-ID: 46E6159A.1000707@emolecules.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-09-11 04:23:11 Re: What to vacuum after deleting lots of tables
Previous Message Luke Lonergan 2007-09-10 22:46:56 Re: random_page_costs - are defaults of 4.0 realistic for SCSI RAID 1