Re: Performance monitor signal handler

Поиск
Список
Период
Сортировка
От Philip Warner
Тема Re: Performance monitor signal handler
Дата
Msg-id 3.0.5.32.20010316111340.02258e90@mail.rhyme.com.au
обсуждение исходный текст
Ответ на Re: Performance monitor signal handler  (Jan Wieck <janwieck@Yahoo.com>)
Ответы Re: Performance monitor signal handler  (Alfred Perlstein <bright@wintelcom.net>)
Список pgsql-hackers
At 06:57 15/03/01 -0500, Jan Wieck wrote:
>
>    And  shared  memory has all the interlocking problems we want
>    to avoid.

I suspect that if we keep per-backend data in a separate area, then we
don;t need locking since there is only one writer. It does not matter if a
reader gets an inconsistent view, the same as if you drop a few UDP packets.


>    What about a collector deamon, fired up by the postmaster and
>    receiving UDP packets from the backends. 

This does sound appealing; it means that individual backend data (IO etc)
will survive past the termination of the backend. I'd like to see the stats
survive the death of the collector if possible, possibly even survive a
stop/start of the postmaster.


>    Now whatever the backend has to tell the collector, it simply
>    throws  a UDP packet into his direction. If the collector can
>    catch it or not, not the backends problem.

If we get the backends to keep the stats they are sending in local counters
as well, then they can send the counter value (not delta) each time, which
would mean that the collector would not 'miss' anything - just it's
operations/sec might see a hiccough. This could have a sidebenefit that(if
wewanted to?) we could allow a client to query their own counters to get an
idea of the costs of their queries.

When we need to reset the counters that should be done explicitly, I think.


----------------------------------------------------------------
Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 0500 83 82 82         |                 ___________ |
Http://www.rhyme.com.au          |                /           \|                                |    --________--
PGP key available upon request,  |  /
and from pgp5.ai.mit.edu:11371   |/


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: Allowing WAL fsync to be done via O_SYNC
Следующее
От: Alfred Perlstein
Дата:
Сообщение: Re: Performance monitor signal handler