> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly