Re: Closing inactive connections OR user connections limits

From: Francisco Reyes <lists(at)natserv(dot)com>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: pgsql General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Closing inactive connections OR user connections limits
Date: 2002-11-20 18:56:36
Message-ID: 20021120135451.V30106-100000@zoraida.natserv.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

On 20 Nov 2002, Neil Conway wrote:

> Francisco Reyes <lists(at)natserv(dot)com> writes:
> > But wouldn't "vacuum full" still fail?
>
> Not if the connection is made to the database as the PostgreSQL
> superuser.

So this would be new to 7.3. Right?
Right now if there are connections open "vacuum full" will wait from those
connectins to close, even if the vacuum is done from the superuser.

> Heh, no where at the moment, as there wasn't isn't any documentation
> on this new feature :-) Attached is a patch that adds some (also sent
> to -patches).

So there will be a way to reserve connectinos for the super-user, but will
there be a way to limit number of connection per user?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Medi Montaseri 2002-11-20 19:00:53 Re: Closing inactive connections OR user connections limits
Previous Message Francisco Reyes 2002-11-20 18:54:33 Re: Closing inactive connections OR user connections limits

Browse pgsql-sql by date

  From Date Subject
Next Message Medi Montaseri 2002-11-20 19:00:53 Re: Closing inactive connections OR user connections limits
Previous Message Francisco Reyes 2002-11-20 18:54:33 Re: Closing inactive connections OR user connections limits