Postgres Pro
Downloads
Home   >   mailing lists

Re: smart shutdown at end of transaction (was: Default mode for shutdown) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: smart shutdown at end of transaction (was: Default mode for shutdown)
Date
Msg-id CA+TgmoaBAr5g1DNqoBkqZ0OAjMpQyG43=ysasGpQKv3AJ7aeKQ@mail.gmail.com
Whole thread Raw
In response to Re: smart shutdown at end of transaction (was: Default mode for shutdown)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: smart shutdown at end of transaction (was: Default mode for shutdown)  (Robert Haas <robertmhaas@gmail.com>)
Re: smart shutdown at end of transaction (was: Default mode for shutdown)  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Tree view 
On Fri, Apr 27, 2012 at 2:48 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm not necessarily opposed to commandeering the name "smart" for the
> new behavior, so that what we have to find a name for is the old "smart"
> behavior.  How about
>
>        slow    - allow existing sessions to finish (old "smart")
>        smart   - allow existing transactions to finish (new)
>        fast    - kill active queries
>        immediate - unclean shutdown

I could live with that.  Really, I'd like to have fast just be the
default.  But the above compromise would still be a big improvement
over what we have now, assuming the new smart becomes the default.

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

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: smart shutdown at end of transaction (was: Default mode for shutdown)
Next
From: Noah Misch
Date:
Subject: Re: psql omits row count under "\x auto"