Re: PostgreSQL Tweaking

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