Re: zabbix on postgresql - very slow delete of events

2019-08-13 Thread Kristian Ejvind
this happens. [cid:imagec5a681.PNG@530b3f9e.479048e5] Kristian Ejvind Linux System Administrator IT Operations | Technical Operations Resurs Bank Ekslingan 8 Box 222 09, SE-25467 Helsingborg Mobil: +46 728571483 Växel: +46 42 38 20 00 E-post: kristian.ejv...@resurs.se<mailto:kris

Re: zabbix on postgresql - very slow delete of events

2019-07-24 Thread Kristian Ejvind
| 0 | 0 | 0 (7 rows) Time: 2.857 ms Time: 0.162 ms Regards Kristian [cid:imageec8d1d.PNG@91acb18e.4997dc74] Kristian Ejvind Linux System Administrator IT Operations | Technical Operations Resurs Bank Ekslingan 8 Box 222 09, SE-25467 Helsingborg Mobil: +4

Re: zabbix on postgresql - very slow delete of events

2019-07-24 Thread Kristian Ejvind
Regards Kristian ?On 2019-07-23, 16:33, "Kenneth Marshall" wrote: On Tue, Jul 23, 2019 at 01:41:53PM +, Kristian Ejvind wrote: > Thanks Kenneth. In fact we've already partitioned the largest history* and trends* tables > and that has been running fine for

Re: zabbix on postgresql - very slow delete of events

2019-07-23 Thread Kristian Ejvind
eeper, and cleaned up by dropping partitions instead everything worked much, much, much better. When we started using partitioning, we used the old inheiritance style. Now you can use the native partitioning. Regards, Ken Resurs Bank AB Kristian Ejvind Linux System Ad

zabbix on postgresql - very slow delete of events

2019-07-23 Thread Kristian Ejvind
userid | clock | mediatypeid | sendto | subject | message | status | retries | error | esc_step | aler ttype | p_eventid | acknowledgeid -+--+-++---+-++-+-++-----+---+------+- --+---+--