Re: Performance monitor

Bruce Momjian <pgman@candle.pha.pa.us>

From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Richard J Kuhns <rjk@grauel.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Karel Zak <zakkr@zf.jcu.cz>, Philip Warner <pjw@rhyme.com.au>, Justin Clift <aa2@bigpond.net.au>, The Hermit Hacker <scrappy@hub.org>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2001-03-08T19:46:03Z
Lists: pgsql-hackers
> Bruce Momjian writes:
> ...
>  > The problem I see with the shared memory idea is that some of the
>  > information needed may be quite large.  For example, query strings can
>  > be very long.  Do we just allocate 512 bytes and clip off the rest.  And
>  > as I add more info, I need more shared memory per backend.  I just liked
>  > the file system dump solution because I could modify it pretty easily,
>  > and because the info only appears when you click on the process, it
>  > doesn't happen often.
>  > 
> Have you thought about using a named pipe?  They've been around for quite a
> while, and should (he said with a :-)) be available on most-if-not-all
> currently supported systems.

Nifty idea.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026