Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1EC5F2E0037 for ; Mon, 17 Mar 2008 23:56:07 -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 59554-06 for ; Mon, 17 Mar 2008 23:55:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from smtp20.orange.fr (smtp20.orange.fr [80.12.242.27]) by postgresql.org (Postfix) with ESMTP id 1CE7D2E002F for ; Mon, 17 Mar 2008 23:56:00 -0300 (ADT) Received: from smtp20.orange.fr (mwinf2018 [172.22.130.118]) by mwinf2010.orange.fr (SMTP Server) with ESMTP id 2311E1C0B355 for ; Mon, 17 Mar 2008 17:40:47 +0100 (CET) Received: from me-wanadoo.net (localhost [127.0.0.1]) by mwinf2018.orange.fr (SMTP Server) with ESMTP id 2C3C21C00056 for ; Mon, 17 Mar 2008 17:37:42 +0100 (CET) Received: from axege.com (LNeuilly-152-22-82-133.w193-251.abo.wanadoo.fr [193.251.23.133]) by mwinf2018.orange.fr (SMTP Server) with ESMTP id E11721C00053 for ; Mon, 17 Mar 2008 17:37:41 +0100 (CET) X-ME-UUID: 20080317163741922.E11721C00053@mwinf2018.orange.fr Received: from localhost (localhost [127.0.0.1]) by axege.com (Postfix) with ESMTP id E742C4FE27 for ; Mon, 17 Mar 2008 18:51:21 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at myhostname="axege.com." Received: from axege.com ([127.0.0.1]) by localhost (axege.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id IoAFSb3L5Nw5 for ; Mon, 17 Mar 2008 18:51:21 +0100 (CET) Received: from [10.0.0.69] (unknown [192.168.1.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by axege.com (Postfix) with ESMTP id 7405E4FE26 for ; Mon, 17 Mar 2008 18:51:21 +0100 (CET) Subject: Re: performance tools From: Franck Routier To: pgsql-performance In-Reply-To: References: <005a01c88843$54e04770$14010a0a@dei26g028575> Content-Type: text/plain; charset=UTF-8 Organization: =?ISO-8859-1?Q?Ax=E8ge?= Sarl Date: Mon, 17 Mar 2008 17:37:42 +0100 Message-Id: <1205771862.14225.13.camel@franck-gusty> Mime-Version: 1.0 X-Mailer: Evolution 2.12.1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/364 X-Sequence-Number: 29318 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