Re: Management tool support and scalibility

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>
Cc: Kevin <TenToThe8th(at)yahoo(dot)com>, PGSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Management tool support and scalibility
Date: 2002-02-03 08:39:19
Message-ID: Pine.GSO.4.44.0202031138450.19830-100000@ra.sai.msu.su
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 3 Feb 2002, Andrew McMillan wrote:

> On Sun, 2002-02-03 at 18:25, Kevin wrote:
> >
> > E.g., Oracle 8i had a very nice management console (and from the glimpse
> > of 9i I got, it's even better). You could look at things like database
> > schemas via a tree view, database physical layouts, user information,
> > and connection information. (I don't have it in front of me at the
> > moment, so I'm sure there is more.) In particular I was very interested
> > in the ability to view not only what query a connection was doing, but
> > which operations it did that took a long time to process (full table
> > scans, etc), which one it is working on now, and how long that one will
> > take. I know a while ago someone was working on a way to get similar
> > kinds of information by attaching to the backends via gdb or something
> > equally dangerous/hackish/error-prone. When would such an ability be
> > put into the system itself? (I believe Oracle does it through system
> > tables, which I would think might be good for PostgreSQL, as it would be
> > hard, and slow, to query each backend every time.)
>
> I believe that TOra is starting to have support for PostgreSQL now,
> although I haven't managed to get it working for myself yet :-)

does it require KDE/Gnome stuff ?

>
> Some of the guys in our office use it for Oracle management and seem to
> think pretty highly of it. I know it supports MySQL as well - can't
> wait until the PostgreSQL support is fully available.
>
> Regards,
> Andrew.
>

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew McMillan 2002-02-03 08:51:44 Re: Management tool support and scalibility
Previous Message Andrew McMillan 2002-02-03 08:27:02 Re: Management tool support and scalibility