Re: postgreSQL performance 8.2.6 vs 8.3.3

Поиск
Список
Период
Сортировка
От David Rees
Тема Re: postgreSQL performance 8.2.6 vs 8.3.3
Дата
Msg-id 72dbd3150902201346p91f033eid6ca1eb38169bac2@mail.gmail.com
обсуждение исходный текст
Ответ на postgreSQL performance 8.2.6 vs 8.3.3  (Battle Mage <battlemage@gmail.com>)
Ответы Re: postgreSQL performance 8.2.6 vs 8.3.3  (david@lang.hm)
Список pgsql-performance
On Fri, Feb 20, 2009 at 1:34 PM, Battle Mage <battlemage@gmail.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
> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Kenneth Marshall
Дата:
Сообщение: Re: postgreSQL performance 8.2.6 vs 8.3.3
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Benchmark comparing PostgreSQL, MySQL and Oracle