Postgres Pro
Downloads
Home   >   mailing lists

Re: an efficient way of checking if the connection to a db - Mailing list pgsql-jdbc

From Tom Lane
Subject Re: an efficient way of checking if the connection to a db
Date
Msg-id 17552.1134685460@sss.pgh.pa.us
Whole thread Raw
In response to Re: an efficient way of checking if the connection to a db  (Kris Jurka <books@ejurka.com>)
Responses Re: an efficient way of checking if the connection to a db  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
Tree view 
Kris Jurka <books@ejurka.com> writes:
> Getting the official driver to provide this interface would require
> demonstrating that the overhead of SELECT 1 is significantly higher than
> Sync.

It probably is.  However, sending an empty query string to the backend
to execute ought to be competitive with a bare Sync.  libpq supports
that; does JDBC?

            regards, tom lane

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: CallableStatements: index starts at 2
Next
From: Kris Jurka
Date:
Subject: Re: an efficient way of checking if the connection to a db