Re: add -s to vacuumdb

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: add -s to vacuumdb
Дата
Msg-id 55491982.6000509@commandprompt.com
обсуждение исходный текст
Ответ на Re: add -s to vacuumdb  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: add -s to vacuumdb  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: add -s to vacuumdb
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: initdb start server recommendation