Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] PClabs Survey, Part I: Administration

From: Constantin Teodorescu <teo(at)flex(dot)ro>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] PClabs Survey, Part I: Administration
Date: 2000-02-02 09:37:33
Message-ID: 3897FADD.7C459CC7@flex.ro (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-interfaces
The Hermit Hacker wrote:
> 

Also, marked with * the options available in PgAccess

> Administration
> - graphical tools for
>     - database administration
>         - installing the database server
>         - creating and managing databases
>         - creating and managing disk devices
>*        - creating and managing users
>*        - creating and managing indicies
>*        - creating and managing stored procedures
>*        - backup and restore operations
>         - creating and managing replication links
>         - Web publishing
>         - database diagramming tools
>         - viewing and entering data into database tables
>         - submitting SQL commands and viewing results
>         - send a message to all logged-in database users
>     - database perforformance tuning
>         - configuring server engine options
>*        - viewing the SQL commands currently executing
>         - detecting resource-intensive queries
>         - killing selected queries
>         - graphing overall server engine statistics
>         - single statement graphical execution plan display
>         - SQL rewrite suggestions for a single SQL statement
>         - index suggestions for a single SQL statement
>         - index suggestions for overall server (based on actual usage)
>         - pre-calculation (summary table) suggestions (based on actual usage)
>         - baselining and then tracking server performance over time

In PgAccess there are also a couple of goodies that are not listed above
as:

- visual query builder
- schema designer

Constantin Teodorescu
FLEX Consulting Braila, ROMANIA

In response to

pgsql-hackers by date

Next:From: HorĂ¡k DanielDate: 2000-02-02 09:43:55
Subject: RE: [HACKERS] PCLabs Survey, Part VII: Embedded Database / Branch Office Support
Previous:From: Zeugswetter Andreas SBDate: 2000-02-02 08:49:25
Subject: AW: [HACKERS] freefuncs.c is never called from anywhere!?

pgsql-interfaces by date

Next:From: Peter MountDate: 2000-02-02 11:37:48
Subject: RE: [INTERFACES] jdbc and ie explorer
Previous:From: Hiroshi InoueDate: 2000-02-02 09:16:26
Subject: RE: [INTERFACES] Seeking advice on how to deal with the dreaded stuck spinlock problem on NT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group