From: | "Jeroen T(dot) Vermeulen" <jtv(at)xs4all(dot)nl> |
---|---|
To: | "Tomasz Myrta" <jasiek(at)klaster(dot)net> |
Cc: | "Leandro Lucarella" <llucarella(at)integratech(dot)com(dot)ar>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: Keep-alive support |
Date: | 2006-11-30 06:33:03 |
Message-ID: | 17164.125.24.223.202.1164868383.squirrel@webmail.xs4all.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-interfaces |
On Thu, November 30, 2006 03:31, Tomasz Myrta wrote:
> I used keepalive the same way as you (reconfiguring socket directly) and
> I don't remember libpq trying to reconnect itself. I think it's a
> libpqxx's behaviour - I didn't use it, but it looks like it is called
> "reactivation".
That's right. It's libpqxx, not libpq, that restores the connection. (It
couldn't really be any other way because libpq doesn't have enough
information to know it's safe--you could be in the middle of a
transaction, or you could be losing a temp table). Automatic reactivation
can also be disabled explicitly if you don't want it (or just *when* you
don't want it--e.g. when you're working with temp tables).
I do think that the long TCP timeouts are something that should be handled
at the lower levels. We can't really do real keepalives, I guess, simply
because libpq is synchronous to the application. But perhaps we could
demand that the server at least acknowledge a request in some way within a
particular time limit? It'd have to be at the lowest level possible and
as "cheap" as possible, so it doesn't break when the server is merely very
busy.
Jeroen
From | Date | Subject | |
---|---|---|---|
Next Message | Jeroen T. Vermeulen | 2006-11-30 08:17:53 | Re: "Optional ident" authentication |
Previous Message | Tom Lane | 2006-11-30 06:30:15 | Re: elog(FATAL)ing non-existent roles during client authentication |
From | Date | Subject | |
---|---|---|---|
Next Message | Leandro Lucarella | 2006-11-30 14:11:08 | Re: Keep-alive support |
Previous Message | Tomasz Myrta | 2006-11-29 20:31:57 | Re: Keep-alive support |