Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches)
От
Kuntal Ghosh
Тема
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches)
Дата
Msg-id
CAGz5QC+wRhdkjasJQZd9DYTcJKUR487guvOvd41H6iDR4WFBDQ@mail.gmail.com
Ответ на
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) (Amit Langote)
Список
Дерево обсуждения
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Andres Freund <andres@anarazel.de>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Magnus Hagander <magnus@hagander.net>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Andres Freund <andres@anarazel.de>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Tracking wait event for latches) Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Andres Freund <andres@anarazel.de>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: exposing wait events for non-backends (was: Trackingwait event for latches) Kuntal Ghosh <kuntalghosh.2007@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] exposing wait events for non-backends (was: Trackingwait event for latches) "David G. Johnston" <david.g.johnston@gmail.com>
Hello Amit,
On Tue, Mar 7, 2017 at 4:24 PM, Amit Langote
wrote:
> Hi Kuntal,
>
> Patches apply and compile fine. Works as advertised.
>
> Some minor comments on the patches themselves.
>
Thanks for the review.
> In 0001:
>
> - * pgstat_bestart() -
> + * pgstat_procstart() -
> + *
> + * Initialize this process's entry in the PgBackendStatus array.
> + * Called from InitPostgres and AuxiliaryProcessMain.
>
> Not being called from AuxiliaryProcessMain(). Maybe leftover comment from
> a previous version. Actually I see that in patch 0002, Main() functions
> of various auxiliary processes call pgstat_procstart, not
> AuxiliaryProcessMain.
>
Fixed.
> + * user-defined functions which expects ids of backends starting from
> 1 to
>
> s/expects/expect/g
>
Fixed.
> +/*
> + * AuxiliaryPidGetProc -- get PGPROC for an auxiliary process
> + * given its PID
> + *
> + * Returns NULL if not found.
> + */
> +PGPROC *
> +AuxiliaryPidGetProc(int pid)
> +{
> + PGPROC *result;
>
> Initialize to NULL so that the comment above is true. :)
>
Fixed.
> In 0002:
>
> @@ -248,6 +248,9 @@ BackgroundWriterMain(void)
> */
> prev_hibernate = false;
>
> + /* report walwriter process in the PgBackendStatus array */
> + pgstat_procstart();
> +
>
> s/walwriter/writer/g
Fixed.
> Patch 0004 should update monitoring.sgml.
Added.
I've attached the updated patches. PFA.
--
Thanks & Regards,
Kuntal Ghosh
EnterpriseDB: http://www.enterprisedb.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Robert Haas
Дата:
От: Robert Haas
Дата: