On 5/2/05, Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> What we can do in PostgreSQL is to introduce an application-level
> heartbeat. A simple "Hello world" message sent from server to client that
> the client would ignore would do the trick.
Hmm, a quick-and-dirty implementation could be that a client issues
"LISTEN heartbeat;" command, and there would be other client issuing
"NOTIFY heartbeat;" every few minutes. I am not sure but this would
probably make server send out these messages to the client, regardless
of whether the client is doing something or not. Again, I am not sure.
Ah, and probably so many NOTIFY messages wouldn't be very nice for
system tables.
Regards,
Dawid
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
