Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 09FFB2E01FB for ; Mon, 17 Mar 2008 12:37:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 38629-01-6 for ; Mon, 17 Mar 2008 12:37:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id 2FA792E008A for ; Mon, 17 Mar 2008 12:27:18 -0300 (ADT) Received: (qmail 6832 invoked from network); 17 Mar 2008 11:28:49 -0400 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 17 Mar 2008 11:28:49 -0400 From: "Mark Steben" To: "'sathiya psql'" , Subject: Re: performance tools Date: Mon, 17 Mar 2008 11:26:54 -0400 Message-ID: <005a01c88843$54e04770$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005B_01C88821.CDCEA770" X-Mailer: Microsoft Office Outlook 11 In-Reply-To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Thread-Index: AciILQPgZlhSiLmtRXSld95pFTuaeQAFibkA X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/345 X-Sequence-Number: 29299 This is a multi-part message in MIME format. ------=_NextPart_000_005B_01C88821.CDCEA770 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 @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... ------=_NextPart_000_005B_01C88821.CDCEA770 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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...

------=_NextPart_000_005B_01C88821.CDCEA770--