From: Ezra Taylor <ezrat@acedsl.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to improve Postgres performance
Date: Tue, 13 Sep 2005 14:25:48 -0700
Message-ID: <432743DC.3000507@acedsl.com> (raw)
In-Reply-To: <OF0B10B43F.9EF2CBBD-ON6525706D.001AC374-6525706D.001BC90F@flextronicssoftware.com>
References: <OF0B10B43F.9EF2CBBD-ON6525706D.001AC374-6525706D.001BC90F@flextronicssoftware.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: ezrat@acedsl.com
Subject: Re: How to improve Postgres performance
In-Reply-To: <432743DC.3000507@acedsl.com>
References: <OF0B10B43F.9EF2CBBD-ON6525706D.001AC374-6525706D.001BC90F@flextronicssoftware.com> <432743DC.3000507@acedsl.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox