Re: Performance monitor

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Richard J Kuhns <rjk(at)grauel(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>, Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Justin Clift <aa2(at)bigpond(dot)net(dot)au>, The Hermit Hacker <scrappy(at)hub(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Performance monitor
Date: 2001-03-08 19:46:03
Message-ID: 200103081946.OAA15563@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-03-08 20:04:22 Re: WAL does not recover gracefully from out-of-disk-sp ace
Previous Message Tom Lane 2001-03-08 19:45:48 Re: Checkpoint process signal handling seems wrong