Re: Performance monitor - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Performance monitor
Date
Msg-id 200103131604.LAA14665@candle.pha.pa.us
Whole thread Raw
In response to Re: Performance monitor  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > My idea is that they can telnet into the server machine and do remote-X
> > with the application.  Just set the DISPLAY variable and it should work.
> 
> Remote X pretty well sucks in the real world.  Aside from speed issues
> there is the little problem of firewalls filtering out X connections.
> 
> If you've got ssh running then you can tunnel the X connection through
> the ssh connection, which fixes the firewall problem, but it makes the
> speed problem worse.  And getting ssh plus X forwarding working is not
> something I want to have to hassle with when my remote database is down.
> 
> If you are thinking of telnet-based remote admin then I suggest you get
> out your curses man page and do up a curses GUI.  (No smiley... I'd
> seriously prefer that to something that depends on remote X.)

Aren't there tools to allow tcl/tk on non-X displays.  I thought SCO had
something.

FYI, about the getrusage() idea, seems that only works for the current
process or it its children, so each backend would have to update its own
statistics.  Seems expensive compared to having 'ps do it.

--  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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Vadim Mikheev"
Date:
Subject: Re: RE: xlog loose ends, continued
Next
From: "Vadim Mikheev"
Date:
Subject: Re: RE: xlog loose ends, continued