Обсуждение: Postgres Performance
Dear All,
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.
Regards
aftab
This e-mail contains PRIVILEGED AND 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, or distribute this e-mail or its contents to any other person and any such actions 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. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right 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.
On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote: > 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. the best setting would be to upgrade. 7.0 was released in 2000, and is practically abandoned. the oldest supported version at the moment is 7.4, but i would strongly suggest to try to move to newest versions - like 8.3.1 regards, hubert lubaczewski -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)
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 configuration. Mean while I am trying to migrate it to 8.3.1 Regards aftab -----Original Message----- From: hubert depesz lubaczewski [mailto:depesz@depesz.com] Sent: Thursday, March 20, 2008 3:27 PM To: Aftab Alam Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Postgres Performance On Thu, Mar 20, 2008 at 03:12:43PM +0530, Aftab Alam wrote: > 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. the best setting would be to upgrade. 7.0 was released in 2000, and is practically abandoned. the oldest supported version at the moment is 7.4, but i would strongly suggest to try to move to newest versions - like 8.3.1 regards, hubert lubaczewski -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV) This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you arenot the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not tocopy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mailmay contain viruses. TSR Darashaw Ltd. has taken every reasonable precaution to minimize this risk, but is not liablefor any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checksbefore opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right to monitor and review the content ofall messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the TSRDarashaw Ltd's e-mail system.
On Thu, Mar 20, 2008 at 04:02:48PM +0530, Aftab Alam wrote: > I have mistaken written 7.0 instead of 7.3, I am getting more than 2000 hits > daily, can u suggest the best configuration. Mean while I am trying to > migrate it to 8.3.1 7.3 is also pretty old. as for 2000 hits daily - it's not much. do you have performance issues? check which queries couse the problems, and "explain analyze" them. then, with explain analyze output, you can fix performance issues in those queries. regards, depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)
> From: aalam@tsrdarashaw.com
> To: depesz@depesz.com
> CC: pgsql-admin@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 than 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.
>
What are the performance 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 parameters or any other solution.
- Vishal
Coolhotmail : Board of the same old Email ID’s? Get a unique one here. Try it now!
Hi Vishal,
Attached is the conf file for your reference.
Regards
aftab
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal 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-admin@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 than 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.
>
What are the performance 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 parameters or any other solution.
- Vishal
Coolhotmail : Board of the same old Email ID’s? Get a unique one here. Try it now!
This e-mail contains PRIVILEGED AND 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, or distribute this e-mail or its contents to any other person and any such actions 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. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right 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.
Вложения
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 supports 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 performance issues.
- Vishal
From: aalam@tsrdarashaw.com
To: aroravishal22@hotmail.com
CC: pgsql-admin@postgresql.org; depesz@depesz.com
Subject: RE: [ADMIN] Postgres Performance
Date: Thu, 20 Mar 2008 18:03:13 +0530
Hi Vishal,
Attached is the conf file for your reference.
Regards
aftab
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Vishal 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-admin@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 than 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.
>
What are the performance 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 parameters or any other solution.
- VishalCoolhotmail : Board of the same old Email ID’s? Get a unique one here. Try it now!
This e-mail contains PRIVILEGED AND 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, or distribute this e-mail or its contents to any other person and any such actions 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. You should carry out your own virus checks before opening the e-mail or attachment. TSR Darashaw Ltd. reserves the right 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.
Coolhotmail : Board of the same old Email ID’s? Get a unique one here. Try it now!