X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB397D8C02 for ; Mon, 12 Sep 2005 15:24:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 13064-09 for ; Mon, 12 Sep 2005 18:24:51 +0000 (GMT) Received: from mail1.acecape.com (mail1.acecape.com [66.114.74.12]) by svr1.postgresql.org (Postfix) with ESMTP id 6D3AAD6F44 for ; Mon, 12 Sep 2005 15:24:50 -0300 (ADT) Received: from [127.0.0.1] (p78-70.acedsl.com [66.114.78.70]) by mail1.acecape.com (8.12.11/8.12.11) with ESMTP id j8CIOn0f005648 for ; Mon, 12 Sep 2005 14:24:51 -0400 Message-ID: <432743DC.3000507@acedsl.com> Date: Tue, 13 Sep 2005 14:25:48 -0700 From: Ezra Taylor User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-admin@postgresql.org Subject: Re: How to improve Postgres performance References: In-Reply-To: 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, hits=2.046 required=5 tests=[DATE_IN_FUTURE_24_48=2.046] X-Spam-Level: ** X-Archive-Number: 200509/110 X-Sequence-Number: 18847 Hemant Pandey wrote: > > >Hi All, > I am running an application, which connects to the postgres >database at initialization time and perform the database operations like >Select/Update. >Database queries are very simple. >On analyzing my application through Quantifier( Performance analyzing >tool), I found the most of the time my application is waiting on recv, >waiting for Database response. >When i run Vacuum on perticular tables, i observed that performance >improoves drastically. > >So please tell me how can i improve database performance through >configuration parameters. I had tried to change parameters in >postgresql.conf file but of no avail. >Now i am trying to Auto Vacuum, but don't know how to run Auto Vacuum. > >Please help me to solve these problems. > >Thanks in advance. >Hemant > >*********************** FSS-Unclassified *********************** >"DISCLAIMER: This message is proprietary to Flextronics Software >Systems Limited (FSS) and is intended solely for the use of the >individual to whom it is addressed. It may contain privileged or >confidential information and should not be circulated or used for >any purpose other than for what it is intended. If you have received >this message in error, please notify the originator immediately. >If you are not the intended recipient, you are notified that you are >strictly prohibited from using, copying, altering, or disclosing >the contents of this message. FSS accepts no responsibility for >loss or damage arising from the use of the information transmitted >by this email including damage from virus." > > >---------------------------(end of broadcast)--------------------------- >TIP 6: explain analyze is your friend > > > Hemant: Check out this document: http://gborg.postgresql.org/project/pgavd/projdisplay.php