To avoid a database shutdown, execute a database-wide VACUUM

Поиск
Список
Период
Сортировка
От Jean-Baptiste Vedel
Тема To avoid a database shutdown, execute a database-wide VACUUM
Дата
Msg-id CAOheMDObsBxmX5hfkGhOzhwZxtomV6BnLewpsoXQ_pNVK8JZUw@mail.gmail.com
обсуждение исходный текст
Ответы Re: To avoid a database shutdown, execute a database-wide VACUUM
Список pgsql-admin
Hello,

I've got a problem with my postgresql database 9.4 this morning.
Few days ago we've moved many data in the database to create new data partitions and delete many entries.
Auto-vacuum seems to be inefficient and i am unable to vacuum my zabbix database.
Do you have any idea about this problem ?

< 2016-03-02 07:04:19.406 CET >WARNING:  database "zabbix" must be vacuumed within 7989357 transactions
< 2016-03-02 07:04:19.406 CET >HINT:  To avoid a database shutdown, execute a database-wide VACUUM in that database.

Best Regards,

В списке pgsql-admin по дате отправления:

Предыдущее
От: Keith
Дата:
Сообщение: Re: monitoring solutions
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: To avoid a database shutdown, execute a database-wide VACUUM