pgjdbc-ng
pgjdbc-ng copied to clipboard
Performance issue where `connection.createArrayOf` always queries database to resolve `typeName`
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.