[ZBX-413] Proposal: To remove feature vacuum (PostgreSQL) of source zabbix Created: 2008 Aug 04  Updated: 2017 May 30  Resolved: 2008 Sep 18

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 1.4, 1.4.1, 1.4.2, 1.4.3, 1.4.4, 1.4.5
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: Fernando Ike de Oliveira Assignee: Alexander Vladishev
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Use Zabbix with storage PostgreSQL Database.


Attachments: File remove_vacuum.patch    

 Description   

The feature vacuum of the zabbix in the new versions PostgreSQL is generaty overhead in the server, because the zabbix execute manually vacuum in the housekeeper table. When it monitors very itens (200 or more) is occuring two or more instance of vacuum the same table (housekeeper). I believe that execute vacuum is responsibility of DBA and execute outside software (zabbix) with jobs or task.

Also The PostgreSQL 8.3 and major has by default feature autovacuum that execute vacuum in the better time and don't have overhead in the server. I remove feature vacuum of the Zabbix and the performance improved considerably to build zabbix without vacuum.



 Comments   
Comment by Fernando Ike de Oliveira [ 2008 Aug 04 ]

Follow remove vacuum patch.

Regards,

Comment by Fernando Ike de Oliveira [ 2008 Aug 04 ]

This patch base version zabbix 1.5.3.

Comment by Eduard Ruzhansky (Inactive) [ 2008 Aug 05 ]

Hello,

Thank you for reporting this.
We have planned to introduce this improvement in the version 1.6, which is to be released on September 18.

Best regards,
Eduard - /Support Engineer/

Comment by Alexei Vladishev [ 2008 Sep 18 ]

Vacuuming has been disabled in 1.6.

Comment by Dennis Ploeger [ 2009 Apr 16 ]

I'd rather turn the feature on again and make it configurable through the configuration file. We had lots of problems with the autovacuum process. It seems only stable from 8.3 on and requires a lot of fine tuning on the postgresql side.

So I turned the autovacuum off and was relying on zabbix until I found out, that the feature had been removed.

I would add a configuration value "vacuum", which is set to off as a default, but can be turned on.

Generated at Wed Jul 09 09:31:24 EEST 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.