On 05/05/2015 12:22 PM, Andrew Dunstan wrote:


On 05/05/2015 03:06 PM, Joshua D. Drake wrote:

Hey folks,

Just had your standard... our pg_ tables are all bloated out, what is
a good way to take care of that. We have -s for reindexdb but not
vacuumdb. Thoughts?



What command will it run? VACUUM doesn't have a SYSTEM flag, unlike REINDEX

The equivalent of:

vacuum (FULL/VERBOSE/ANALYZE/FREEZE) pg_*

Just like REINDEX/reindexdb

JD

--
Command Prompt, Inc. - http://www.commandprompt.com/  503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Announcing "I'm offended" is basically telling the world you can't
control your own emotions, so everyone else should do it for you.


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to