Re: ps_status on fastpath - Mailing list pgsql-hackers

From Tom Lane
Subject Re: ps_status on fastpath
Date
Msg-id 4101.1292613917@sss.pgh.pa.us
Whole thread Raw
In response to Re: ps_status on fastpath  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: ps_status on fastpath  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Excerpts from Tom Lane's message of vie dic 17 12:41:06 -0300 2010:
>> Hm, what about pgstat_report_activity()?

> I wasn't sure about that, because of the overhead, but now that I look
> at it, it's supposed to be cheaper than changing the ps_status in some
> cases, so I guess there's no harm.

Yeah, if we can afford a possible kernel call to set ps status, it
doesn't seem like pgstat_report_activity should be a problem.  I'm
also of the opinion that more people look at pg_stat_activity than
ps output these days.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal: FOREACH-IN-ARRAY (probably for 9.2?)
Next
From: Robert Haas
Date:
Subject: Re: unlogged tables vs. GIST