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