Re: Performance evaluation of PostgreSQL's historic releases

Поиск
Список
Период
Сортировка
От György Vilmos
Тема Re: Performance evaluation of PostgreSQL's historic releases
Дата
Msg-id dac6660e0909301121v4f48a0a2tfe99d8d563c5f785@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Performance evaluation of PostgreSQL's historic releases  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general


2009/9/30 Scott Marlowe <scott.marlowe@gmail.com>
On Tue, Sep 29, 2009 at 4:47 PM, Greg Smith <gsmith@gregsmith.com> wrote:
> P.S. On your write-heavy tests, increasing checkpoint_segments a lot should
> improve overall performance, if you re-test at some point.

Just wanted to add that in order to really test a db, you need a
benchmark that runs a lot longer than a few minutes.  I routinely use
tests that run for hours to get an idea how things like write ahead
logging and such affect the db under heavy, long term load.

Agreed, but even with 5x1 minutes of test runs for each threads it took a week to do all the tests.

I've once heard that a company have spent three man years for performance testing one of its products...

--
http://suckit.blog.hu/

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

Предыдущее
От: György Vilmos
Дата:
Сообщение: Re: Performance evaluation of PostgreSQL's historic releases
Следующее
От: Ricky Tompu Breaky
Дата:
Сообщение: Re: I can not drop a user/role because an object depent on it.