On Fri, Feb 20, 2009 at 1:34 PM, Battle Mage <battlemage@xxxxxxxxx> 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 > tps? 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. -Dave -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance