Skip site navigation (1) Skip section navigation (2)

Re: Postgres Performance

From: Aftab Alam <aalam(at)tsrdarashaw(dot)com>
To: 'Vishal Arora' <aroravishal22(at)hotmail(dot)com>
Cc: <pgsql-admin(at)postgresql(dot)org>, <depesz(at)depesz(dot)com>
Subject: Re: Postgres Performance
Date: 2008-03-20 12:33:13
Message-ID: 36daef3d-b052-479b-84a3-2359278f8578 (view raw or flat)
Thread:
Lists: pgsql-admin
Hi Vishal,

Attached is the conf file for your reference.

Regards
aftab

________________________________
From: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Vishal Arora
Sent: Thursday, March 20, 2008 4:34 PM
To: Aftab Alam; depesz(at)depesz(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgres Performance





________________________________

> From: aalam(at)tsrdarashaw(dot)com
> To: depesz(at)depesz(dot)com
> CC: pgsql-admin(at)postgresql(dot)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!<http://www.ideacellular.com/IDEA.portal>

________________________________
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.

Attachment: postgresql.conf
Description: text/plain (5.2 KB)

In response to

Responses

pgsql-admin by date

Next:From: Abraham, DannyDate: 2008-03-20 13:28:41
Subject: Looking for performance monitoring tool for PG
Previous:From: Vishal AroraDate: 2008-03-20 11:03:38
Subject: Re: Postgres Performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group