pgjdbc-ng icon indicating copy to clipboard operation
pgjdbc-ng copied to clipboard

Performance issue where `connection.createArrayOf` always queries database to resolve `typeName`

Open JamesDunne opened this issue 7 months ago • 0 comments

In v0.8.9, every invocation of the PGDirectConnection#createArrayOf method queries the database to resolve the typeName string to an oid which is then looked up in the SharedRegistry instance.

When executing a large batch of queries utilizing array parameters, this extra query per invocation is causing significant and noticeable unnecessary overhead.

JamesDunne avatar Mar 03 '25 15:03 JamesDunne