Re: New to PostgreSQL, performance considerations

Поиск
Список
Период
Сортировка
От Brad Nicholson
Тема Re: New to PostgreSQL, performance considerations
Дата
Msg-id 1165933705.15903.77.camel@dba5.int.libertyrms.com
обсуждение исходный текст
Ответ на Re: New to PostgreSQL, performance considerations  ("Daniel van Ham Colchete" <daniel.colchete@gmail.com>)
Список pgsql-performance
On Mon, 2006-12-11 at 20:22 -0200, Daniel van Ham Colchete wrote:
>
> I'm thinking about writing a script to make all the tests (more than 3
> times each), get the data and plot some graphs.
>
> I don't have the time right now to do it, maybe next week I'll have.

Check out the OSDL test suite stuff.  It runs the test and handles all
the reporting for you (including graphs).
http://www.osdl.org/lab_activities/kernel_testing/osdl_database_test_suite/

> I invite everyone to comment/sugest on the procedure or the results.

I'd recommend running each test for quite a bit longer.  Get your
buffers dirty and exercised, and see what things look like then.

Also, if you have the disk, offload your wal files to a separate disk.
--
Brad Nicholson  416-673-4106
Database Administrator, Afilias Canada Corp.


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

Предыдущее
От: Michael Stone
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations
Следующее
От: Alexander Staubo
Дата:
Сообщение: Re: New to PostgreSQL, performance considerations