(resending to remove HTML formatting)

I have an API server and I'm trying to be conscientious managing Postgres's 
resources carefully. On the client side, I have a Hikari Pool.

Usually when I need a connection, I simply create a default read/write 
connection, even if I don't plan to make any updates or inserts or hold any 
locks. But most of my database connections are in fact read-only.

I saw that when you create a JDBC connection, you can specify readOnly=true. 
Would doing so somehow help Postgres manage its other connections? Perhaps 
Postgres, knowing that a connection is readOnly and will never even attempt to 
do an update, will free up some internal resources for other connections. Is 
this accurate?

Reply via email to