From: | Francisco Reyes <lists(at)natserv(dot)com> |
---|---|
To: | pgsql General List <pgsql-general(at)postgresql(dot)org> |
Subject: | Closing inactive connections OR user connections limits |
Date: | 2002-11-20 16:52:38 |
Message-ID: | 20021120114805.C29739-100000@zoraida.natserv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-sql |
I have read on the archives some type of per user limit that will be
available in 7.3, but what do I do in the meantime with a 7.2.X.
Basically I came this morning to find a developer had a bug in a program
and used up all the connections. Could I have safely killed those
connections?
I had to do a "pgsql stop -m fast" to free the connections, but I had some
pending operations which now I will have to redo, not to mention the
vacuum full failed last night because of the open connections.
In all the archives I read there seems to be a negative view on timeouts.
I think that after 4 hours of no activity, at least in my case, I
definitely want those connections dead.
In particular this is a reporting server and I delete/reload millions of
records daily so anything which stops the vacuum full at night is a big
problem for me.
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco J Reyes | 2002-11-20 17:14:07 | Re: Hardware estimation |
Previous Message | Williams, Travis L, NPONS | 2002-11-20 16:38:20 | Grant question.. |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2002-11-20 17:00:51 | Re: Problems invoking psql. Help please. |
Previous Message | Josh Berkus | 2002-11-20 16:49:50 | Re: trying to learn plpqsql... so please forgive.. |