| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: add -s to vacuumdb |
| Date: | 2015-05-05 19:26:58 |
| Message-ID: | 55491982.6000509@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2015-05-05 19:36:07 | Re: initdb start server recommendation |
| Previous Message | Andrew Dunstan | 2015-05-05 19:22:52 | Re: add -s to vacuumdb |