> > It will be tck/tk, so I guess X only.
> 
>  Good point. A typical DB server -- where is performance important -- 
> has install Xwin?
> 
>  BTW, I hate Oracle 8.x.x because has X+java based installer, but some
> my servers hasn't monitor and keyboard let alone to Xwin.
> 
>  What implement performance monitor as client/server application where
> client is some shared lib? This solution allows to create more clients
> for more differents GUI. I know... it's easy planning, but the other 
> thing is programming it  :-)

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.

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

Tue, 13 Mar 2001 09:56:56 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance monitor
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.
> 

Well, actually you would want to tunnel your X session through ssh if
security of the database server is of any importance...  But this works
fine on high bandwidth connections, but X is a real pain if you are sitting
with low bandwidth(e.g. cellphone connection when you're in the middle of
nowhere on your favorite vacation ;-)

regards, 

	Gunnar

13 Mar 2001 16:36:25 +0100
Gunnar R|nning <gunnar@candleweb.no>
Re: Performance monitor
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.)

			regards, tom lane

Tue, 13 Mar 2001 11:01:07 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: Performance monitor 
> 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, Pennsylvania 19026

Tue, 13 Mar 2001 11:04:25 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Performance monitor