Closing inactive connections OR user connections limits

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.

Responses

Browse pgsql-general by date

  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..

Browse pgsql-sql by date

  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..