Zabbix 2.2.2 - PostgreSQL Partitioning

[arut55]

Hello Dears..
Anyone can give me instruction for partitioning with PostgreSQL
Zabbix version 2.2.2
PostgreSQL version 9.3

[f.koch]

Hi,

take a look here

http://www.zabbix.org/wiki/Higher_performant_partitioning_in_PostgreSQL

regards f0

[arut55]

Thank you for answer.
But it use cron.
I want to do same without using cron jobs.

Hi,

take a look here

http://www.zabbix.org/wiki/Higher_performant_partitioning_in_PostgreSQL

regards f0

[BDiE8VNy]

Be aware of possible race conditions when considering non-scheduled ways of partition maintenance:

Some procedures make use of partition maintenance/creation within the insert trigger function as well. That is a very bad practice as it could lead to a race condition and should be avoided [7] - especially in larger Zabbix setups.

[soulhunter]

I agree with this, race conditions can be problematic, this procedure is prone to race conditions, and will fail to insert some (the first data in the day/month, if two or more inserts occur concurrently):

https://www.zabbix.org/wiki/Docs/howto/zabbix2_postgresql_autopartitioning

Be aware of possible race conditions when considering non-scheduled ways of partition maintenance: