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?