| From: | Maciek Sakrejda <msakrejda(at)truviso(dot)com> |
|---|---|
| To: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
| Cc: | PG-JDBC Mailing List <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify |
| Date: | 2009-12-21 01:24:39 |
| Message-ID: | 895e58dd0912201724r6b798469t4879e48a0d0abae2@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-jdbc |
> So my question is: is there any particularly low-overhead statement that
> might be suitable for generating pointless client/server chat to check for
> received async notifications? Should I just use "SELECT 1" ? Or would I be
> better off using a SHOW statement like "SHOW role" to avoid creating a
> snapshot etc?
>
Does the jdbc driver work with EmptyQueryResponse? At the protocol
level, if you send a Query message with an all-whitespace sql string,
the backend is supposed to reply with a single EmptyQueryResponse
message and then issue ReadyForQuery again. I have a feeling that jdbc
is probably "too smart" for this to work, but it could be worth a
shot.
---
Maciek Sakrejda | Software Engineer | Truviso
1065 E. Hillsdale Blvd., Suite 230
Foster City, CA 94404
(650) 242-3500 Main
(650) 242-3501 F
msakrejda(at)truviso(dot)com
www.truviso.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John DeSoi | 2009-12-21 01:30:11 | Re: Extended Query, flush or sync ? |
| Previous Message | John R Pierce | 2009-12-20 22:21:18 | Re: Something like Oracle Forms, but Open Source to use with PostgreSQL? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2009-12-21 01:36:55 | Re: Cheapest way to poll for notifications? & Driver improvement question re SSL and notify |
| Previous Message | Alexander Pyhalov | 2009-12-19 09:47:59 | Re: Get bytes sent to client |