Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group