From: | Durumdara <durumdara(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Disconnect/Resource releasing/PING |
Date: | 2011-03-21 10:33:29 |
Message-ID: | AANLkTiksPPeoeurPUacRLxc8sKusE3mfsOXP2E5p9uxz@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
Many databases (like Firebird) have some time limitation for the clients.
These cases possible with client:
a.) It is working, but network connection is temp. down.
b.) The client is crashing
c.) The client is on, but it is not working for N minutes.
When the server experience that client is not speaking in N minutes, the
handle and all resources will be freed.
I want to know about this case in PG.
1.) Do I need to PING the server periodically N minutes with "select time()"
query to keep the handle live?
2.) What happened, if client crashed, or died? WHen the resources (temp
tables, cursors, etc) freed?
3.) Can I configure this per databases, or only per server?
4.) If I use PGDAC or ZEOS to access PG are them make this PING
automatically?
5.) What happens if a client died but it's query (long) is running? Is query
cancelled by the server, or wait for finish?
6.) If a long query running the client can got timeout because it is cannot
work?
Thanks for your help:
dd
From | Date | Subject | |
---|---|---|---|
Next Message | Zheng Yang | 2011-03-21 12:17:09 | foreign data wrappers |
Previous Message | Durumdara | 2011-03-21 10:22:43 | Linux, Hungarian charset (Win1250) is supports the hungarian collation? |