Re: Background Processes and reporting - Mailing list pgsql-hackers

From Vladimir Borodin
Subject Re: Background Processes and reporting
Date
Msg-id 2B2B07A2-D75D-4422-8C23-A6FDDF019020@simply.name
Whole thread Raw
In response to Re: Background Processes and reporting  (Andres Freund <andres@anarazel.de>)
Responses Re: Background Processes and reporting
List pgsql-hackers

12 марта 2016 г., в 0:22, Andres Freund <andres@anarazel.de> написал(а):

On 2016-03-11 23:53:15 +0300, Vladimir Borodin wrote:
It was many times stated in threads about waits monitoring [0, 1, 2]
and supported by different people, but ultimately waits information
was stored in PgBackendStatus.

Only that it isn't. It's stored in PGPROC.  

Sorry, I missed that. So monitoring of wait events for auxiliary processes still could be implemented?

This criticism is true of
the progress reporting patch, but a quick scan of the thread doesn't
show authors of the wait events patch participating there.


Can’t we think one more time about implementation provided by Ildus
and Alexander here [3]?

I don't think so. Afaics the proposed patch tried to do too many things
at once, and it's authors didn't listen well to criticism.  Trying to go
back to that seems like a surefire way to have nothing in 9.6.

The idea is not to try implement all that at once (and more in 9.6) but give an ability to implement all that features eventually. If it is still possible, it’s great.



Seems that current implementation doesn’t give reasonable ways to
implement all that features and it is really sad.

Why is that?

Storing information about wait event in 4 bytes gives an ability to store only wait type and event. No way to store duration or extra information (i.e. buffer number for I/O events or buffer manager LWLocks). Maybe I’m missing something...



Andres Freund


--
May the force be with you…

pgsql-hackers by date:

Previous
From: Joel Jacobson
Date:
Subject: Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.
Next
From: Pavel Stehule
Date:
Subject: Re: [COMMITTERS] pgsql: Provide much better wait information in pg_stat_activity.