X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5D6FED1B52F for ; Tue, 28 Oct 2003 06:22:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 20613-10 for ; Tue, 28 Oct 2003 02:21:40 -0400 (AST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id 663E6D1B50D for ; Tue, 28 Oct 2003 02:21:39 -0400 (AST) Received: from myrealbox.com shridhar_daithankar@smtp-send.myrealbox.com [202.54.11.72] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.43 $ on Novell NetWare via secured & encrypted transport (TLS); Mon, 27 Oct 2003 23:21:33 -0700 Message-ID: <3F9E0AE9.7070302@myrealbox.com> Date: Tue, 28 Oct 2003 11:51:29 +0530 From: Shridhar Daithankar User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5) Gecko/20031013 Thunderbird/0.3 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Kamalraj Singh Madhan Cc: pgsql-performance@postgresql.org Subject: Re: Optimizing Performance References: <00c601c39d1b$ca129880$4ecb09c0@KAMALR> In-Reply-To: <00c601c39d1b$ca129880$4ecb09c0@KAMALR> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/697 X-Sequence-Number: 4445 Kamalraj Singh Madhan wrote: > Hi, > I'am having major performance issues with post gre 7.3.1 db. Kindly suggest all the possible means by which i can optimize the performance of this database. If not all, some ideas (even if they are common) are also welcome. There is no optimisation done to the default configuration of the installed database. Kindly suggest. Check http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html Shridhar