Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4324B2E00EC for ; Thu, 20 Mar 2008 13:52:40 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 68781-04 for ; Thu, 20 Mar 2008 13:52:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from blu139-omc3-s18.blu139.hotmail.com (blu139-omc3-s18.blu139.hotmail.com [65.55.175.218]) by postgresql.org (Postfix) with ESMTP id 9CE092E0070 for ; Thu, 20 Mar 2008 13:52:24 -0300 (ADT) Received: from BLU110-W16 ([65.55.162.189]) by blu139-omc3-s18.blu139.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 20 Mar 2008 09:52:22 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_208fc200-fe00-4c72-aca4-6775071211d7_" X-Originating-IP: [220.226.31.172] From: Vishal Arora To: Aftab Alam CC: Subject: Re: Postgres Performance Date: Thu, 20 Mar 2008 22:22:22 +0530 Importance: Normal In-Reply-To: <36daef3d-b052-479b-84a3-2359278f8578> References: <36daef3d-b052-479b-84a3-2359278f8578> MIME-Version: 1.0 X-OriginalArrivalTime: 20 Mar 2008 16:52:22.0498 (UTC) FILETIME=[C472A420:01C88AAA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.94 tagged_above=0 required=5 tests=AWL=-0.564, HTML_MESSAGE=0.001, RCVD_IN_NJABL_PROXY=1.693, RCVD_IN_SBL=2.81 X-Spam-Level: *** X-Archive-Number: 200803/174 X-Sequence-Number: 28657 --_208fc200-fe00-4c72-aca4-6775071211d7_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable Based on your conf file.. you can increase shared buffers and also you can = increase the max_connections. (I am not sure if your version of Postgres su= pports more than 32 connections. Just check that). Apart from that you can = use Explain Analyze on any specific query which you think is having any per= formance issues. =20 - Vishal From: aalam@tsrdarashaw.comTo: aroravishal22@hotmail.comCC: pgsql-admin@pos= tgresql.org; depesz@depesz.comSubject: RE: [ADMIN] Postgres PerformanceDate= : Thu, 20 Mar 2008 18:03:13 +0530 Hi Vishal, =20 Attached is the conf file for your reference. =20 Regards aftab =20 From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql= .org] On Behalf Of Vishal AroraSent: Thursday, March 20, 2008 4:34 PMTo: Af= tab Alam; depesz@depesz.comCc: pgsql-admin@postgresql.orgSubject: Re: [ADMI= N] Postgres Performance =20 > From: aalam@tsrdarashaw.com> To: depesz@depesz.com> CC: pgsql-admin@postg= resql.org> Subject: Re: [ADMIN] Postgres Performance> Date: Thu, 20 Mar 200= 8 16:02:48 +0530> > Dear Hubert,> > I have mistaken written 7.0 instead of = 7.3, I am getting more than 2000 hits> daily, can u suggest the best config= uration. Mean while I am trying to> migrate it to 8.3.1> Still 7.3 is an o= lder version. > > I am using postgres 7.0 with linux with 15 GB of database= & 3> gb of RAM.> > Can anyone suggest what is the best setting for postgre= s. I am using> postgres as web db.> What are the performance issues you are= facing? What are the settings you have made in you postgreSQL.conf file? B= ased on that we can suggest you to tune some parameters or any other soluti= on. - Vishal Coolhotmail : Board of the same old Email ID=92s? Get a unique one here. Tr= y it now! This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solel= y for the use of the addressee(s). If you are not the intended recipient, p= lease notify the sender by e-mail and delete the original message. Further,= you are not to copy, disclose, or distribute this e-mail or its contents t= o any other person and any such actions are unlawful. This e-mail may conta= in viruses. TSR Darashaw Ltd. has taken every reasonable precaution to mini= mize this risk, but is not liable for any damage you may sustain as a resul= t of any virus in this e-mail. You should carry out your own virus checks b= efore opening the e-mail or attachment. TSR Darashaw Ltd. reserves the righ= t to monitor and review the content of all messages sent to or from this e-= mail address. Messages sent to or from this e-mail address may be stored on= the TSR Darashaw Ltd's e-mail system. _________________________________________________________________ Fashion Channel : Want to know what=92s the latest in the fashion world ? Y= ou have it all here on MSN Fashion. http://lifestyle.in.msn.com/= --_208fc200-fe00-4c72-aca4-6775071211d7_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable

Based on your conf file.. you can increas= e shared buffers and also you can increase the max_connections. (I am not s= ure if your version of Postgres supports more than 32 connections. Just che= ck that). Apart from that you can use Explain Analyze on any specific query= which you think is having any performance issues.
 
- Vishal


From: aalam@tsrdarashaw.com
To: aroravishal22@hotmail.com
CC: pgsql-a= dmin@postgresql.org; depesz@depesz.com
Subject: RE: [ADMIN] Postgres Per= formance
Date: Thu, 20 Mar 2008 18:03:13 +0530


Hi Vishal,

 =

Attached is the conf= file for your reference.

 =

Regards

aftab<= /P>

 =


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgre= sql.org] On Behalf Of Visha= l Arora
Sent: Thursday, = March 20, 2008 4:34 PM
To: Aftab Alam; depesz@depesz.com
Cc= : pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres Performance

=

 





> From:= aalam@tsrdarashaw.com
> To: depesz@depesz.com
> CC: pgsql-admi= n@postgresql.org
> Subject: Re: [ADMIN] Postgres Performance
> = Date: Thu, 20 Mar 2008 16:02:48 +0530
>
> Dear Hubert,
>=
> I have mistaken written 7.0 instead of 7.3, I am getting more tha= n 2000 hits
> daily, can u suggest the best configuration. Mean while= I am trying to
> migrate it to 8.3.1
>
 
Still 7.3 is an older version.

> > I am using postgres 7.0 with linux with 15 GB of = database & 3
> gb of RAM.
> > Can anyone suggest what is= the best setting for postgres. I am using
> postgres as web db.
&= gt;

What are the per= formance issues you are facing? What are the settings you have made in you = postgreSQL.conf file? Based on that we can suggest you to tune some paramet= ers or any other solution.
 
- Vishal

Coolhotmail : Board of the same old Email ID= =92s? Get a unique one here. Try it now!



This e-mail contains PRIVILEGED A= ND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s)= . If you are not the intended recipient, please notify the sender by e-mail= and delete the original message. Further, you are not to copy, disclose, o= r distribute this e-mail or its contents to any other person and any such a= ctions are unlawful. This e-mail may contain viruses. TSR Darashaw Ltd. has= taken every reasonable precaution to minimize this risk, but is not liable= for any damage you may sustain as a result of any virus in this e-mail. Yo= u should carry out your own virus checks before opening the e-mail or attac= hment. TSR Darashaw Ltd. reserves the right to monitor and review the conte= nt of all messages sent to or from this e-mail address. Messages sent to or= from this e-mail address may be stored on the TSR Darashaw Ltd's e-mail sy= stem.


Coolhotmail : Board of the same ol= d Email ID=92s? Get a unique one here. Try it now! = --_208fc200-fe00-4c72-aca4-6775071211d7_--