Re: Hooks for session start and end, take two

On Fri, Sep 27, 2019 at 4:26 PM legrand legrand <legrand_legrand(at)hotmail(dot)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,

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:

+ /* just consider normal backends */
+ if (MyBackendId == InvalidBackendId)
+ return;

But one thing came to my mind, why not in this first version we hook just
normal backends?

Regards,

--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento