Thread

1. Re: Performance monitor

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-03-13T14:56:56Z

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

2. Re: Performance monitor

   Gunnar R|nning <gunnar@candleweb.no> — 2001-03-13T15:36:25Z

   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
   
   

3. Re: Performance monitor

   Tom Lane <tgl@sss.pgh.pa.us> — 2001-03-13T16:01:07Z

   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
   
   

4. Re: Performance monitor

   Bruce Momjian <pgman@candle.pha.pa.us> — 2001-03-13T16:04:25Z

   > 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