How to set optimizer_switch='index_condition_pushdown=off' in PostgreSQL!

[ghiyasimehr]

Hi All,

I'm getting this error in zabbix_server.log: "slow query: 62.356972 sec, "select distinct itemid from trends_uint where clock".

After that Zabbix was stopped with this log: "Zabbix Server stopped. Zabbix 3.4.9 (revision 80550)."

I use PostgreSQL. I checked Zabbix doc & I found that in MySQL, disabling the index_condition_pushdown optimizer will resolve it.

But there isn't this option in PostgreSQL. How can I resolve this error?

[kernbug]

Hi

Why did you decide that this option is suitable for PostgreSQL and will be the solution to any problems with Zabbix performance?
What is your Zabbix Server NVPS value?

[ghiyasimehr]

Hi kernbug,
If this option isn't the solution for PostgreSQL, What's the solution for PostgreSQL about Zabbix slow query fatal error?
What's NVPS value? How can I get it?