Re: DISCARD ALL (Again)

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Re: DISCARD ALL (Again)
Дата
Msg-id 20140418021515.GT2556@tamriel.snowman.net
обсуждение исходный текст
Ответ на Re: DISCARD ALL (Again)  (David G Johnston <david.g.johnston@gmail.com>)
Список pgsql-hackers
* David G Johnston (david.g.johnston@gmail.com) wrote:
> > On 04/17/2014 05:24 PM, Tom Lane wrote:
> > > On the whole I'm not sure this is something we ought to get into.
> > > If you really need a fresh session, maybe you should start a
> > > fresh session.
> >
> Isn't the whole point to avoid the reconnection overhead, especially for
> connection poolers?  DISCARD ALL shouldn't cause any cleanup that wouldn't
> otherwise occur when a session disconnects.  True global data (not just
> session global) should be excluded.

Err, this is per-backend global data, so it will get cleaned up on
session disconnect.

> A better wording of the promise would be: "discard all" leaves the session
> in the same state it would be in if the underlying connection were dropped
> and re-established.

This is not accurate.
Thanks,
    Stephen

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

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: DISCARD ALL (Again)
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: DISCARD ALL (Again)