From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | dz(at)cs(dot)unitn(dot)it (Massimo Dal Zotto) |
Cc: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] keeping track of connections |
Date: | 1998-06-08 16:05:24 |
Message-ID: | 199806081605.MAA10388@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> >
> > On Thu, 4 Jun 1998, David Gould wrote:
> >
> > > Oh, ok. Some suggestions have been made the the postmaster would open a
> > > connection to it's own backend to do queries. I was responding to this.
> > > I agree that we should just store the information in shared memory.
> >
> > How does one get a history for long term monitoring and statistics
> > by storing in shared memory?
> >
> > Marc G. Fournier
> > Systems Administrator @ hub.org
> > primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
> Why not simply append history lines to a normal log file ? In this way you
> don't have the overhead for accessing tables and can do real-time processing
> of the data with a simple tail -f on the file.
> I use this trick to monitor the log file written by 30 backends and it works
> fine for me.
I agree. We have more important items to address.
--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-06-08 16:24:06 | Cancel key now ready |
Previous Message | Bruce Momjian | 1998-06-08 16:04:27 | Re: [HACKERS] backend now show status in 'ps' |