Re: add -s to vacuumdb
| От | Fabrízio de Royes Mello |
|---|---|
| Тема | Re: add -s to vacuumdb |
| Дата | |
| Msg-id | CAFcNs+p0VkhBQLNegV6idfZSwt6pMffFg53LQcyOJXy4iUErWQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: add -s to vacuumdb ("Joshua D. Drake" <jd@commandprompt.com>) |
| Список | pgsql-hackers |
On Tue, May 5, 2015 at 4:26 PM, Joshua D. Drake <jd@commandprompt.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
>
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.
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
В списке pgsql-hackers по дате отправления: