Re: What to vacuum after deleting lots of tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: What to vacuum after deleting lots of tables
Дата
Msg-id 18593.1189484591@sss.pgh.pa.us
обсуждение исходный текст
Ответ на What to vacuum after deleting lots of tables  (Craig James <craig_james@emolecules.com>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Craig James
Дата:
Сообщение: What to vacuum after deleting lots of tables
Следующее
От: Ruben Rubio
Дата:
Сообщение: [Again] Postgres performance problem