Re: an efficient way of checking if the connection to a db

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: Assad Jarrahian <jarraa(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: an efficient way of checking if the connection to a db
Date: 2005-12-15 22:24:20
Message-ID: 17552.1134685460@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Kris Jurka <books(at)ejurka(dot)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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2005-12-15 22:41:23 Re: an efficient way of checking if the connection to a db
Previous Message Dave Cramer 2005-12-15 22:19:43 Re: CallableStatements: index starts at 2