| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Jeff Lanzarotta <delux256-postgresql(at)yahoo(dot)com> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL GENERAL List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: How does server handle clients that disconnect ungracefully? |
| Date: | 2007-04-24 15:39:02 |
| Message-ID: | 20070424153902.GE2579@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 24, 2007 at 07:16:38AM -0700, Jeff Lanzarotta wrote:
> OK, that is what the other fellow said... It depends on the TCP/IP
> stack...
>
> Thanks again for the clarification.
Note, there are two cases. If only the program crashes but the system
is fine, the kernel will close the socket for you straight away and the
server with notice the hangup.
The only time the server will wait for a time out is if the server and
the client are on different machines and something disrupts actual
communications. If the client machine crashes without notifying the
server, or someone pulls out a network cable. If the client and the
server are on the same machine, it will always notice.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2007-04-24 15:41:43 | Re: View is not using a table index |
| Previous Message | Andy Dale | 2007-04-24 15:35:09 | Generic triggers ? |