In issue ZBXNEXT-6492 (Possibility for usage jdbc connection string for PostgreSQL Patroni cluster), functionality for clustered JDBC connections was added to Zabbix 8.0. The functionality allows Zabbix to select the active read and write node of the PostgreSQL cluster for both read and write queries.

To optimize database and Zabbix frontend performance, read-only requests could be directed to the stand-by node to reduce load on the active primary node.

This cloud be possible to implement for views like Dashboards, Problems and Latest Data.

The option would be preferably be optional, depending on the database configuration (Async, Sync). Meaning if it's vital to ensure the most up-to-date data is viewed, then reads would also always be to the send to the active node as is the current implementation.