[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: |
![]() |
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. Best regards, |
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. |