pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedperformance tools
6+ messages / 5 participants
[nested] [flat]
* performance tools
@ 2008-03-17 07:57 sathiya psql <sathiya.psql@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: sathiya psql @ 2008-03-17 07:57 UTC (permalink / raw)
To: pgsql-performance
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...
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: performance tools
@ 2008-03-17 15:26 Mark Steben <msteben@autorevenue.com>
parent: sathiya psql <sathiya.psql@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Mark Steben @ 2008-03-17 15:26 UTC (permalink / raw)
To: 'sathiya psql' <sathiya.psql@gmail.com>; pgsql-performance
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
@utoRevenueT
A Dominion Enterprises Company
480 Pleasant Street
Suite B200
Lee, MA 01238
413-243-4800 Home Office
413-243-4809 Corporate Fax
msteben <blocked::mailto:name@autorevenue.com> @autorevenue.com
Visit our new website at
<blocked::http://www.autorevenue.com/; 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...
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: performance tools
@ 2008-03-17 15:46 sathiya psql <sathiya.psql@gmail.com>
parent: Mark Steben <msteben@autorevenue.com>
0 siblings, 3 replies; 6+ messages in thread
From: sathiya psql @ 2008-03-17 15:46 UTC (permalink / raw)
To: Mark Steben <msteben@autorevenue.com>; pgsql-performance
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...
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: performance tools
@ 2008-03-17 16:07 Ben Chobot <bench@silentmedia.com>
parent: sathiya psql <sathiya.psql@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Ben Chobot @ 2008-03-17 16:07 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: pgsql-performance
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...
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: performance tools
@ 2008-03-17 16:37 Franck Routier <franck.routier@axege.com>
parent: sathiya psql <sathiya.psql@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Franck Routier @ 2008-03-17 16:37 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: performance tools
@ 2008-03-17 22:06 Andrej Ricnik-Bay <andrej.groups@gmail.com>
parent: sathiya psql <sathiya.psql@gmail.com>
2 siblings, 0 replies; 6+ messages in thread
From: Andrej Ricnik-Bay @ 2008-03-17 22:06 UTC (permalink / raw)
To: sathiya psql <sathiya.psql@gmail.com>; +Cc: pgsql-performance
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
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2008-03-17 22:06 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-17 07:57 performance tools sathiya psql <sathiya.psql@gmail.com>
2008-03-17 15:26 ` Mark Steben <msteben@autorevenue.com>
2008-03-17 15:46 ` sathiya psql <sathiya.psql@gmail.com>
2008-03-17 16:07 ` Ben Chobot <bench@silentmedia.com>
2008-03-17 16:37 ` Franck Routier <franck.routier@axege.com>
2008-03-17 22:06 ` Andrej Ricnik-Bay <andrej.groups@gmail.com>
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