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.