Re: add -s to vacuumdb

On Tue, May 5, 2015 at 4:26 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>
wrote:
>
>
> 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
>

IMHO isn't difficult to add a --system option to vacuumdb and would be
nice to have a --schema option too.

Some time ago I proposed to add SCHEMA option to VACUUM command [1] but it
was not very well accepted and the better way is add more options to
vacuumdb. I started a patch to add more powers to --tables option to
vacuumdb but unfortunately I had no time to finish it.

I know it's another thing but the internal refactoring in vacuumdb to
support it enable us to add --system and --schema options also.

Regards,

[1]
http://www.postgresql.org/message-id/CAFcNs+pHJLmLM9n=B6aofV3XPpwHq+znnEjV9UkvPNSZyegXow@mail.gmail.com

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL
>> Timbira: http://www.timbira.com.br
>> Blog: http://fabriziomello.github.io
>> Linkedin: http://br.linkedin.com/in/fabriziomello
>> Twitter: http://twitter.com/fabriziomello
>> Github: http://github.com/fabriziomello