Skip to content

Upgrade pgJDBC to Improve PreparedStatement Performance #36683

@ShenFeng312

Description

@ShenFeng312

I found that in pgJDBC, calling prepareStatement retrieves metadata before executing the SQL.
This behavior disables binary transfer, which forces subsequent queries to fall back to string-based transfer and requires an extra sendParse execution.

I have already fixed this issue in pgJDBC.
Upgrading to a newer version of pgJDBC will allow us to benefit from this fix and improve prepared statement performance.
see pgjdbc/pgjdbc#3783

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions