Re: Added columns to pg_stat_activity

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Neil Conway" <neilc(at)samurai(dot)com>, "PostgreSQL-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Added columns to pg_stat_activity
Date: 2005-05-07 15:04:53
Message-ID: 2682.1115478293@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
> I guess that's from not reading things carefully enough. I looked for
> where "backend pid" was transmitted, because I thought that would be a
> good place to put it. Which might bring up the question, why are things
> like the backend pid sent in msghdr and not in bestart?

I think the PID is used as the lookup key to associate messages from the
same backend. You need some such key, though BackendId (sinval slot
number) is another workable candidate.

regards, tom lane

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2005-05-07 15:45:02 Re: [PATCHES] Patch for database locale settings
Previous Message Tom Lane 2005-05-07 15:02:34 Re: Added columns to pg_stat_activity