Scenario: -PostgreSQL 13 latest version; -I have some reporting users, with "SELECT,REFERENCES" permissions on all tables in the public schema. -Connections are established using the jdbc "readonly" attribute.
Does PostgreSQL perform any optimization on queries in this scenario to avoid establishing locks? Or are these queries treated like any other? Thanks 😊
