Re: Fastest way to check aliveness of connection - Mailing list pgsql-jdbc

From Daniel Migowski
Subject Re: Fastest way to check aliveness of connection
Date
Msg-id 47C517D9.9020405@ikoffice.de
Whole thread Raw
In response to Re: Fastest way to check aliveness of connection  (Oliver Jowett <oliver@opencloud.com>)
List 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


pgsql-jdbc by date:

Previous
From: dmp
Date:
Subject: Array Char/VarChar Size
Next
From: Kris Jurka
Date:
Subject: Re: Array Char/VarChar Size