Re: add -s to vacuumdb - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: add -s to vacuumdb
Date
Msg-id 55491982.6000509@commandprompt.com
Whole thread Raw
In response to Re: add -s to vacuumdb  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: add -s to vacuumdb  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: add -s to vacuumdb
Next
From: Peter Eisentraut
Date:
Subject: Re: initdb start server recommendation