Re: Limited performance on multi core server - Mailing list pgsql-performance

From Claus Guttesen
Subject Re: Limited performance on multi core server
Date
Msg-id b41c75520712120248i269f250bvaedcd0ff2e8ed7c4@mail.gmail.com
Whole thread Raw
In response to Re: Limited performance on multi core server  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
List pgsql-performance
> > Does anyone have any ideas what my bottle neck might be and what I can do
> > about it?
>
> Your bottleneck is that you are using a very old version of PostgreSQL. Try
> 8.2 or (if you can) the 8.3 beta series -- it scales a _lot_ better in this
> kind of situation.

You won't know until you've seen what queries are performed. Changing
db-parameters is a short-term solution, upgrading to a newer version
does require some planning.

--
regards
Claus

When lenity and cruelty play for a kingdom,
the gentlest gamester is the soonest winner.

Shakespeare

pgsql-performance by date:

Previous
From: "Claus Guttesen"
Date:
Subject: Re: Limited performance on multi core server
Next
From: Sven Geisler
Date:
Subject: Re: Limited performance on multi core server