| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Jean-Baptiste Vedel <jb(dot)vedel(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: To avoid a database shutdown, execute a database-wide VACUUM |
| Date: | 2016-03-02 09:05:41 |
| Message-ID: | CAECtzeUTnW_RXy63wHJ7H16eQ6+RBmcgqHQvmsujeUminDNHeg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
2016-03-02 8:04 GMT+01:00 Jean-Baptiste Vedel <jb(dot)vedel(at)gmail(dot)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.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2016-03-02 14:09:12 | Re: To avoid a database shutdown, execute a database-wide VACUUM |
| Previous Message | Jean-Baptiste Vedel | 2016-03-02 07:04:52 | To avoid a database shutdown, execute a database-wide VACUUM |