On Fri, Feb 20, 2009 at 1:34 PM, Battle Mage <battlemage(at)gmail(dot)com> wrote:
> The amount of tps almost doubled, which is good, but i'm worried about the
> load. For my application, a load increase is bad and I'd like to keep it
> just like in 8.2.6 (a load average between 3.4 and 4.3). What parameters
> should I work with to decrease the resulting load average at the expense of
Why is it bad? High load can mean a number of things.
The only way to reduce the load is to get the client to submit
requests slower. I don't think you'll be successful in tuning the
database to run slower. I think you're headed in the wrong direction.
In response to
pgsql-performance by date
|Next:||From: Robert Haas||Date: 2009-02-20 21:54:58|
|Subject: Re: Benchmark comparing PostgreSQL, MySQL and Oracle|
|Previous:||From: Kenneth Marshall||Date: 2009-02-20 21:45:50|
|Subject: Re: postgreSQL performance 8.2.6 vs 8.3.3|