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 A4508D1B561 for ; Tue, 28 Oct 2003 16:15:53 +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 15365-07 for ; Tue, 28 Oct 2003 12:15:21 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id D5D4ED1B568 for ; Tue, 28 Oct 2003 12:15:21 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id h9SGFINu088408 for ; Tue, 28 Oct 2003 16:15:18 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id h9SGA2I8087542 for pgsql-performance@postgresql.org; Tue, 28 Oct 2003 16:10:02 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Optimizing Performance Date: Tue, 28 Oct 2003 10:59:37 -0500 Organization: Hub.Org Networking Services Lines: 22 Message-ID: <60he1t8iae.fsf@dev6.int.libertyrms.info> References: <00c601c39d1b$ca129880$4ecb09c0@KAMALR> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1003 (Gnus v5.10.3) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:tNOXkL8zkkTqXnkF/ugiARVSKII= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/703 X-Sequence-Number: 4451 kamalr@networkprograms.com ("Kamalraj Singh Madhan") writes: > 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. The best single document I am aware of on tuning the database may be found here: That may help with some of your problems, but there can be no guarantees. What ultimately must happen is for you to discover what are the bottlenecks on your system and addressing them. That involves a process of exploration, as opposed to one of doing some unambiguous "best practices." -- select 'cbbrowne' || '@' || 'libertyrms.info'; Christopher Browne (416) 646 3304 x124 (land)