Re: Management tool support and scalibility

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

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.
--
--------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington
WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267
Are you enrolled at http://schoolreunions.co.nz/ yet?