pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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

   



view thread (2+ messages)

Message-ID: <432743DC.3000507@acedsl.com>
Permalink:  ../432743DC.3000507@acedsl.com/
Also on:    postgresql.org/message-id/432743DC.3000507@acedsl.com

 · 

reply

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