Postgres Pro
Downloads
Home   >   mailing lists

Thread: performance tools

performance tools

From
"sathiya psql"
Date:
hi all,
I want this mail to be continued about summary of performance tuning tools... or other postgres related tools..

I ll start with saying there is a tool SCHEMASPY ( i got to know about this from this group only ), this will draw ER diagram and gives interesting informations about our postgres database..


What are all the other opensource tools available like this for seeing informations about our postgres database... and tools for finetuning our postgres database....

Please join with me and summarize the names and usage of the tools....

Use SchemaSpy a very easily installable and usable tool...

Re: performance tools

From
"Mark Steben"
Date:

Toad Data Modeler from Quest Software is an E/R diagram tool that works for us.

And – it has a freeware version.

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our new website at
www.autorevenue.com

 

IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited.  If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it.  Thank you.

From: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] On Behalf Of sathiya psql
Sent: Monday, March 17, 2008 3:58 AM
To: pgsql-performance@postgresql.org
Subject: [PERFORM] performance tools

 

hi all,
I want this mail to be continued about summary of performance tuning tools... or other postgres related tools..

I ll start with saying there is a tool SCHEMASPY ( i got to know about this from this group only ), this will draw ER diagram and gives interesting informations about our postgres database..


What are all the other opensource tools available like this for seeing informations about our postgres database... and tools for finetuning our postgres database....

Please join with me and summarize the names and usage of the tools....

Use SchemaSpy a very easily installable and usable tool...

Re: performance tools

From
"sathiya psql"
Date:
i thought many a replies will come... but only one..

common guys... it may be helping you in tuning your database indirectly, post that tool also, give some informations such as

Tool Name: Schemaspy
Open Source: YES
Database: Postgres
URL: http://sourceforge.net/projects/schemaspy/1
Following can be taken as optional..
Easily Installable: YES
Performance TUNING tool: Partially YES ( YES / NO / Partially Yes )
ER diagram tool: Yes / No
Query Analysis Tool: Yes / No

Probably other informations also

common start sharing...

Re: performance tools

From
Ben Chobot
Date:
Have you tried the archive search tool for this very mailing list? There's a wealth of information imparted all the time, and tuning is generally about knowledge of what's happening, not blindly following the output of some program.


On Mar 17, 2008, at 8:46 AM, sathiya psql wrote:

i thought many a replies will come... but only one..

common guys... it may be helping you in tuning your database indirectly, post that tool also, give some informations such as

Tool Name: Schemaspy
Open Source: YES
Database: Postgres
URL: http://sourceforge.net/projects/schemaspy/1
Following can be taken as optional..
Easily Installable: YES
Performance TUNING tool: Partially YES ( YES / NO / Partially Yes )
ER diagram tool: Yes / No
Query Analysis Tool: Yes / No

Probably other informations also

common start sharing...

Re: performance tools

From
"Andrej Ricnik-Bay"
Date:
On 18/03/2008, sathiya psql <sathiya.psql@gmail.com> wrote:
> i thought many a replies will come... but only one..
You *ARE* aware of the fact that many people on this planet
aren't in your time-zone, eh?  And as Ben pointed out: there's
been a good lot of similar questions - people who want to know
can actually find them using the search on this page:

http://archives.postgresql.org/


Cheers,
Andrej

Re: performance tools

From
Franck Routier
Date:
Hi,

ok, what about Squirrel-Sql ?

Tool Name: Squirrel sql
Free software: YES
URL: http://squirrel-sql.sourceforge.net/

Java multi-rdbms sql client.
Run on Linux, Windows, ...

Easily Installable: YES
Performance TUNING tool: don't know what this means :)
ER diagram tool: Yes
Query Analysis Tool: Yes

+ autocompletion, hibernate plugin (HQL), parametrized queries, ...



ttp://squirrel-sql.sourceforge.net/
Le lundi 17 mars 2008 à 21:16 +0530, sathiya psql a écrit :
> i thought many a replies will come... but only one..
>
> common guys... it may be helping you in tuning your database
> indirectly, post that tool also, give some informations such as
>
> Tool Name: Schemaspy
> Open Source: YES
> Database: Postgres
> URL: http://sourceforge.net/projects/schemaspy/1
> Following can be taken as optional..
> Easily Installable: YES
> Performance TUNING tool: Partially YES ( YES / NO / Partially Yes )
> ER diagram tool: Yes / No
> Query Analysis Tool: Yes / No
>
> Probably other informations also
>
> common start sharing...
--
Franck Routier
Axège Sarl - 23, rue Saint-Simon, 63000 Clermont-Ferrand (FR)
Tél : +33 463 059 540
mèl : franck.routier@axege.com