Catalog Bloat in Development - Frequently dropping/adding schemas and objects

Поиск
Список
Период
Сортировка
От David Johnston
Тема Catalog Bloat in Development - Frequently dropping/adding schemas and objects
Дата
Msg-id 020301cd5638$28943010$79bc9030$@yahoo.com
обсуждение исходный текст
Ответы Re: Catalog Bloat in Development - Frequently dropping/adding schemas and objects  (Ben Madin <lists@remoteinformation.com.au>)
Список pgsql-general

In my current development environment I often drop some or all of the schemas in the database and then re-create them schemas and the objects they contain.  When I go to bring up the database in my GUI it takes a considerable amount of time to initialize.  I suspect this is because the catalog tables are becoming bloated.  What is the recommended course of action to de-bloat them?  Running an unqualified vacuum does not seem to help.  Is it better to just periodically drop and recreate the database itself or would a vacuum with specific tables listed be sufficient – and if so which tables?

 

Thanks!

 

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Chambers
Дата:
Сообщение: Promotion of standby to master
Следующее
От: Misa Simic
Дата:
Сообщение: LEFT and RIGHT JOIN