pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Constantin Teodorescu <teo@flex.ro>
To: The Hermit Hacker <scrappy@hub.org>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] PClabs Survey, Part I: Administration
Date: Wed, 02 Feb 2000 11:37:33 +0200
Message-ID: <3897FADD.7C459CC7@flex.ro> (raw)
References: <Pine.BSF.4.21.0001311730410.480-100000@thelab.hub.org>

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



view thread (2+ messages)

Message-ID: <3897FADD.7C459CC7@flex.ro>
Permalink:  ../3897FADD.7C459CC7@flex.ro/
Also on:    postgresql.org/message-id/3897FADD.7C459CC7@flex.ro

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: teo@flex.ro, scrappy@hub.org
  Subject: Re: [INTERFACES] PClabs Survey, Part I: Administration
  In-Reply-To: <3897FADD.7C459CC7@flex.ro>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox