Java's org.postgresql.util.PSQLState is missing common PostgreSQL Error Codes

2019-01-30 Thread David Kremer
In my Java API server, I am using SERIALIZABLE transaction isolation mode, so I'm specially handling the error code of "40001 serialization_failure", which can occur often. I'm getting the error code String using SQLException's getSQLState() function. Therefore I was surprised to see that the

Does creating readOnly connections, when possible, free up resources in Postgres?

2019-01-27 Thread David Kremer
(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

Does creating readOnly connections, when possible, free up resources in Postgres?

2019-01-27 Thread David Kremer
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