X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C71279DC9B4 for ; Wed, 22 Feb 2006 06:47:33 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88483-10 for ; Wed, 22 Feb 2006 06:47:35 -0400 (AST) X-Greylist: delayed 01:03:55.324282 by SQLgrey- Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by postgresql.org (Postfix) with ESMTP id 0AE3B9DC800 for ; Wed, 22 Feb 2006 06:47:30 -0400 (AST) Received: from [213.162.97.75] (helo=mail.metronet.co.uk) by pih-relay06.plus.net with esmtp (Exim) id 1FBrWv-0002Ia-9l; Wed, 22 Feb 2006 10:47:33 +0000 Received: from mainbox.archonet.com (84-51-143-99.archon037.adsl.metronet.co.uk [84.51.143.99]) by smtp.metronet.co.uk (MetroNet Mail) with ESMTP id EA893407E00; Wed, 22 Feb 2006 10:47:25 +0000 (GMT) Received: from [192.168.1.17] (client17.office.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 7D3AB15EA6; Wed, 22 Feb 2006 10:47:25 +0000 (GMT) Message-ID: <43FC413C.8090909@archonet.com> Date: Wed, 22 Feb 2006 10:47:24 +0000 From: Richard Huxton User-Agent: Thunderbird 1.5 (X11/20051201) MIME-Version: 1.0 To: "Chethana, Rao (IE10)" Cc: pgsql-performance@postgresql.org Subject: Re: References: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> In-Reply-To: <544485BC51F81A41AC1A72CFA69013654D93B6@AZ18EV805.global.ds.honeywell.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200602/338 X-Sequence-Number: 17324 Chethana, Rao (IE10) wrote: > > This is Chethana. I need to know how to improve the performance of > postgresql. It is rich in features but slow in performance. You'll need to provide some details first. How are you using PostgreSQL? How many concurrent users? Mostly updates or small selects or large summary reports? What hardware do you have? What configuration changes have you made? Are you having problems with all queries or only some? Have you checked the plans for these with EXPLAIN ANALYSE? Have you made sure your tables are vacuumed and analysed? That should be a start -- Richard Huxton Archonet Ltd