Re: Fastest way to check aliveness of connection

From: Daniel Migowski <dmigowski(at)ikoffice(dot)de>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Fastest way to check aliveness of connection
Date: 2008-02-27 07:57:13
Message-ID: 47C517D9.9020405@ikoffice.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello Oliver,

Oliver Jowett schrieb:
> Running an empty query ("") is probably the simplest way.
>
> In theory you could do something slightly faster at the protocol level
> (just send Sync and wait for ReadyForQuery) but there's no interface
> currently exposed to do that and I doubt that it will be much faster
> than an empty query anyway.
Yes, I investigated that, but since the normal query procedure also just
sends one package, the gain for just sending the sync does not really
matter. Of course, your idea with the empty query is great. Thanks alot.

With best regards,
Daniel Migowski

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2008-02-29 16:59:17 Re: Array Char/VarChar Size
Previous Message dmp 2008-02-27 07:35:38 Array Char/VarChar Size