Postgres Pro
Downloads
Home   >   mailing lists

Re: proposal: DROP DATABASE variant that kills active sessions - Mailing list pgsql-hackers

From Robert Haas
Subject Re: proposal: DROP DATABASE variant that kills active sessions
Date
Msg-id CA+TgmobWB6tdy5d_4c4SrHuM7RKBaWBKZGiEntCMjrd+MaP2Pg@mail.gmail.com
Whole thread Raw
In response to Re: proposal: DROP DATABASE variant that kills active sessions  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: DROP DATABASE variant that kills active sessions  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Re: proposal: DROP DATABASE variant that kills active sessions  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
On Fri, Oct 16, 2015 at 6:22 AM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> in GoodData we have this feature implemented - little bit different named -
> DROP DATABASE FORCE
>
> It is useful in complex environment with mix of pooled and not pooled
> connections - and in our environment - about 2K databases per server with
> lot of dropped / created databases per server / per day.
>
> I can publish this patch, if there will be any interest.

I think this would be a useful feature.  What would one do about
prepared transactions?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Foreign join pushdown vs EvalPlanQual
Next
From: Robert Haas
Date:
Subject: Re: remaining open items