Does it make sense to upgrade to a newer PostgreSQL JDBC driver? I would like to know if it could be possible to gain any performance benefits from upgrading the default PostgreSQL JDBC drivers from applications like Confluence or JIRA.

Assume that you cannot modify the application that is using them, the question if there are any visible benefits from switching from the current driver postgresql-8.4-702.jdbc3.jar to something newer?


the backend is using PostgreSQL 9.1 and soon will be upgraded to 9.3
JVM being used is the latest 1.7 from Oracle


Does it make sense or not? If so, which version should I pick?
You should always ensure that the JDBC driver is at least as new as the back-end server.

PostgreSQL's catalogs change between major versions, and other details like the bytea quoting method, string escaping features, etc have also changed over time. PgJDBC contains compatibility code to cope with this by querying the server version. If you don't use a current driver, you may have issues with some features, particularly JDBC metadata access and bytea fields.