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