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

From: Jean-Baptiste Vedel <jb(dot)vedel(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: To avoid a database shutdown, execute a database-wide VACUUM
Date: 2016-03-02 07:04:52
Message-ID: CAOheMDObsBxmX5hfkGhOzhwZxtomV6BnLewpsoXQ_pNVK8JZUw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guillaume Lelarge 2016-03-02 09:05:41 Re: To avoid a database shutdown, execute a database-wide VACUUM
Previous Message Keith 2016-02-29 22:17:51 Re: monitoring solutions