Read-only connectios optimizatios

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Read-only connectios optimizatios
Date: 2025-01-25 14:55:20
Message-ID: CPVP215MB18233EA81EAAD56516064077CFE22@CPVP215MB1823.LAMP215.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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 😊

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Frits Hoogland 2025-01-25 16:59:55 Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
Previous Message Pavel Stehule 2025-01-25 13:32:36 Re: Any risk or overhead considerations for frequently executing queries against catalog tables?