Re: smart shutdown at end of transaction (was: Default mode for shutdown)

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: smart shutdown at end of transaction (was: Default mode for shutdown)
Дата
Msg-id 4F9AF52F.7000704@enterprisedb.com
обсуждение исходный текст
Ответ на Re: smart shutdown at end of transaction (was: Default mode for shutdown)  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: smart shutdown at end of transaction (was: Default mode for shutdown)  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: smart shutdown at end of transaction (was: Default mode for shutdown)  (Simon Riggs <simon@2ndQuadrant.com>)
Список pgsql-hackers
On 27.04.2012 21:56, Tom Lane wrote:
> Magnus Hagander<magnus@hagander.net>  writes:
>> On Fri, Apr 27, 2012 at 20:48, 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")
>
>> How about "wait" instead of "slow"?
>
> I kinda liked "slow" vs "fast", but if you think that's too cute ...
> ("wait" doesn't seem very good, though, since all these except immediate
> are waiting, just for different things.)

All the modes indeed wait (except for immediate), so I think it would 
make sense to define the modes in terms of *what* they wait for.
wait sessions    - allow existing sessions to finish (old "smart")wait transactions    - allow existing transactions to
finish(new)wait checkpoint    - kill active querieswait none - unclean shutdown
 

Hmm, the latter two are perhaps a bit confusing. So maybe:
wait_sessions    - allow existing sessions to finish (old "smart")wait_transactions    - allow existing transactions to
finish(new)fast    - kill active queriesimmediate - unclean shutdown
 

Just thinking out loud here..

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: psql omits row count under "\x auto"
Следующее
От: Aakash Goel
Дата:
Сообщение: Re: xReader, double-effort (was: Temporary tables under hot standby)