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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Horák Daniel | 2000-02-02 09:43:55 | RE: [HACKERS] PCLabs Survey, Part VII: Embedded Database / Branch Office Support |
Previous Message | Zeugswetter Andreas SB | 2000-02-02 08:49:25 | AW: [HACKERS] freefuncs.c is never called from anywhere!? |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-02-02 11:37:48 | RE: [INTERFACES] jdbc and ie explorer |
Previous Message | Hiroshi Inoue | 2000-02-02 09:16:26 | RE: [INTERFACES] Seeking advice on how to deal with the dreaded stuck spinlock problem on NT |