Postgres Pro
Downloads
Home   >   mailing lists

Read-only connectios optimizatios - Mailing list pgsql-performance

From Edson Richter
Subject Read-only connectios optimizatios
Date
Msg-id CPVP215MB18233EA81EAAD56516064077CFE22@CPVP215MB1823.LAMP215.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: Read-only connectios optimizatios
List pgsql-performance
Tree view
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 😊 

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Any risk or overhead considerations for frequently executing queries against catalog tables?
Next
From: Frits Hoogland
Date:
Subject: Re: Any risk or overhead considerations for frequently executing queries against catalog tables?