Re: Does creating readOnly connections, when possible, free up resources in Postgres? - Mailing list pgsql-general

From Tom Lane
Subject Re: Does creating readOnly connections, when possible, free up resources in Postgres?
Date
Msg-id 16252.1548617501@sss.pgh.pa.us
Whole thread Raw
In response to Does creating readOnly connections, when possible, free upresources in Postgres?  ("David Kremer" <jkorders@gmx.com>)
List pgsql-general
"David Kremer" <jkorders@gmx.com> writes:
> I saw that when you create a JDBC connection, you can specify readOnly=true. Would doing so somehow help Postgres
manageits other connections? Perhaps Postgres, knowing that a connection is readOnly and will never even attempt to do
anupdate, will free up some internal resources for other connections. Is this accurate? 

No.

            regards, tom lane


pgsql-general by date:

Previous
From: "David Kremer"
Date:
Subject: Does creating readOnly connections, when possible, free upresources in Postgres?
Next
From: Adrian Klaver
Date:
Subject: Re: Query help