Julien Viet

can you clarify @estet90 ?

interesting concern @bradnewman perhaps we can add an extension that query the database when the connection is created to know the OID ? do you know how other client/driver implement...

I believe we could have something similar but that would trigger when the connection is established instead

@BillyYccc ping :-)

@BillyYccc ping :-)

I believe that's not something the client support can easily because it really depends on each database and implementation. Looking at the code of JDBC client for PostgreSQL, it seems...

it would be more efficient to use pg database info, if we do this in the client, then we might wrongly interpret the code and you would need to wait...

I think your use case is valid. However one issue with explicitly created prepared statement caching is the shared cache itself: you cannot evict a prepared statement from the shared...

do we have examples of JDBC client pool behaving this way ? i.e caching prepared statement between connection use ?

if we go this way, then I think this would be more something belonging to the pooled connection part of the code base and not the actual socket connection that...