Re: Availability of pg_backend_pid() immediately after connection establishment

> Someone in this group mentioned a while back that 
> pg_backend_pid() function works only after some 1/2 second 
> after the connection has been established.  This had 
> something to do with the stats collector to make its sweep 
> every .5 seconds?.  Does anyone have more information on this?

No, pg_backend_pid() returns MyProcPid, which is set on backend startup.

However, the different pg_stat_* views won't work until a message has
been passed down to the stats collector, that is correct.

//Magnus