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 6E816D1B544 for ; Tue, 28 Oct 2003 06:11:55 +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 20711-05 for ; Tue, 28 Oct 2003 02:11:25 -0400 (AST) Received: from mail.networkprograms.com (unknown [203.190.139.254]) by svr1.postgresql.org (Postfix) with ESMTP id 983BFD1B50D for ; Tue, 28 Oct 2003 02:11:22 -0400 (AST) Received: from KAMALR ([192.9.203.78]) by mail.networkprograms.com (8.12.9/8.12.9) with SMTP id h9S6AeqG031041 for ; Tue, 28 Oct 2003 11:40:40 +0530 Message-ID: <008201c39d1a$e2064c80$4ecb09c0@KAMALR> Reply-To: "Kamalraj Singh Madhan" From: "Kamalraj Singh Madhan" To: Subject: Optimizing Performance Date: Tue, 28 Oct 2003 11:45:28 +0530 MIME-Version: 1.0 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Scanned-By: MIMEDefang 2.35 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline X-Archive-Number: 200310/775 X-Sequence-Number: 4523 Hi, I'am having major performance issues with post gre 7.3.1 db. Kindly s= uggest all the possible means by which i can optimize the performance of th= is database. If not all, some ideas (even if they are common) are also welc= ome. There is no optimisation done to the default configuration of the inst= alled database. Kindly suggest.=20=20 regards Kamalraj