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

Re: PostgreSQL Tweaking

From: Corrie Strydom <corrie206(at)gmail(dot)com>
To: renier <renier(at)vvconsult(dot)co(dot)za>
Cc: jnbpug(at)postgresql(dot)org
Subject: Re: PostgreSQL Tweaking
Date: 2010-04-09 09:01:44
Message-ID: l2w42984ce11004090201uaa63c407i2a9df2d34cc5a8f0@mail.gmail.com (view raw or flat)
Thread:
Lists: jnbpug
On Fri, Apr 9, 2010 at 10:27 AM, renier <renier(at)vvconsult(dot)co(dot)za> wrote:

>  Hi There.  Is there anyone in the SA PostgreSQL community that is willing
> to assist us.
>
>
>
> We started trials on PostgreSQL just over a year ago, so we used on old
> desktop lying around as our database server, which served fine for testing
> purposes. We eventually bought a new server (2x2.93GHZ Quad core Xeon, 32GB
> RAM, 6x450GB SAS 15000RPM drives etc), quite a decent machine, but the
> performance on this machine is the same, if not worse, than it is on our old
> “server”.  We tried tweaking the postgres.conf file but we do not really
> have enough knowledge of this file and performance does not increase, or the
> service wont start.
>
>
>
> Is there anyone out there with enough experience in postgreSQL tweaking
> that might be willing to assist in some db tuning, and help us learn?
>
>
> Regards,
>
> Renier
>

Hi Renier, you'll have to be bit more specific regarding the setup there?

1) What version of postgres?
2)  What type of application will be using it? Website/intranet site/custom
app ect?
3) How many connections are we talking here?
4) Maybe post your current config files to the web somewhere, where people
can have a look?

More information you can give, the easier people can help you guys?

Corrie

In response to

jnbpug by date

Next:From: Alastair TurnerDate: 2010-04-09 10:09:02
Subject: Re: PostgreSQL Tweaking
Previous:From: renierDate: 2010-04-09 08:27:18
Subject: PostgreSQL Tweaking

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