Postgres Pro
Downloads
Home   >   mailing lists

Re: To avoid a database shutdown, execute a database-wide VACUUM - Mailing list pgsql-admin

From Guillaume Lelarge
Subject Re: To avoid a database shutdown, execute a database-wide VACUUM
Date
Msg-id CAECtzeUTnW_RXy63wHJ7H16eQ6+RBmcgqHQvmsujeUminDNHeg@mail.gmail.com
Whole thread Raw
In response to To avoid a database shutdown, execute a database-wide VACUUM  (Jean-Baptiste Vedel <jb.vedel@gmail.com>)
List pgsql-admin
Tree view
Hi,

2016-03-02 8:04 GMT+01:00 Jean-Baptiste Vedel <jb.vedel@gmail.com>:
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.


Why are you unable to VACUUM your zabbix database? because it is the solution to your issue.


--

pgsql-admin by date:

Previous
From: Jean-Baptiste Vedel
Date:
Subject: To avoid a database shutdown, execute a database-wide VACUUM
Next
From: Guillaume Lelarge
Date:
Subject: Re: To avoid a database shutdown, execute a database-wide VACUUM