Events table partitioning

[syepes]

Hello,

I am searching for some feedback on partitioning the "events" table, if anyone could share their experiences and techniques it would be helpful.
Would like to find the best solution but the issue is that now on Zabbix 3.2, the events table is linked "foreign keys" with the following tables (event_recovery, problem, event_tag, alerts,acknowledges) and this is not a good companion with partitioning or at least in PostgreSQL.


Thanks in advance for any suggestions.

[jan.garaj]

Ryan has published Partitioning scripts for Zabbix on PostgreSQL recently - https://monitoringartist.github.io/z...l_partitioning

[syepes]

Thanks for pointing me to that one!