Re: Hooks for session start and end, take two
От
Fabrízio de Royes Mello
Тема
Re: Hooks for session start and end, take two
Дата
Msg-id
CAFcNs+qt6n7j-Qbes7Na_nwyytLkp91cK-jV=bo8EYsdnh9cug@mail.gmail.com
Ответ на
Re: Hooks for session start and end, take two (legrand legrand)
Список
Дерево обсуждения
Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two legrand legrand <legrand_legrand@hotmail.com>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two legrand legrand <legrand_legrand@hotmail.com>
Re: Hooks for session start and end, take two Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Andres Freund <andres@anarazel.de>
Re: Hooks for session start and end, take two Tom Lane <tgl@sss.pgh.pa.us>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Andres Freund <andres@anarazel.de>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Andres Freund <andres@anarazel.de>
Re: Hooks for session start and end, take two Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: Hooks for session start and end, take two Andres Freund <andres@anarazel.de>
Re: Hooks for session start and end, take two Mike Palmiotto <mike.palmiotto@crunchydata.com>
RE: Hooks for session start and end, take two "tsunakawa.takay@fujitsu.com" <tsunakawa.takay@fujitsu.com>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Hooks for session start and end, take two Tom Lane <tgl@sss.pgh.pa.us>
Re: Hooks for session start and end, take two Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Hooks for session start and end, take two Michael Paquier <michael@paquier.xyz>
Re: Hooks for session start and end, take two Mike Palmiotto <mike.palmiotto@crunchydata.com>
On Fri, Sep 27, 2019 at 4:26 PM legrand legrand <legrand_legrand@hotmail.com> wrote:
>
> OK I confirm:
> - "client backend" appears at session start and end hook,
> - "autovacuum worker" and "pg_background" only appears at session end hook
> (backend_start can be retreived from pg_stat_activity),
> - "parallel workers" are not visible at all
> (because extension cannot assign XIDs during a parallel operation)
>
> All seems fine to me.
>
Hi all,
--
>
> OK I confirm:
> - "client backend" appears at session start and end hook,
> - "autovacuum worker" and "pg_background" only appears at session end hook
> (backend_start can be retreived from pg_stat_activity),
> - "parallel workers" are not visible at all
> (because extension cannot assign XIDs during a parallel operation)
>
> All seems fine to me.
>
Hi all,
First of all thanks Michael for bringing this to life again.
I poked a little with the patch and everything is ok. Your check for normal backend on test_session_hooks is much simpler than I did before:
But one thing came to my mind, why not in this first version we hook just normal backends?
Regards,
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
В списке pgsql-hackers по дате отправления
