Re: New to PostgreSQL, performance considerations

Поиск
Список
Период
Сортировка
От Alexander Staubo
Тема Re: New to PostgreSQL, performance considerations
Дата
Msg-id 2FC0D8E7-F8ED-452F-BB13-FB665B516E7F@purefiction.net
обсуждение исходный текст
Ответ на Re: New to PostgreSQL, performance considerations  ("Daniel van Ham Colchete" <daniel.colchete@gmail.com>)
Ответы Re: New to PostgreSQL, performance considerations
Список pgsql-performance
On Dec 11, 2006, at 23:22 , Daniel van Ham Colchete wrote:

> I ran this test at a Gentoo test machine I have here. It's a Pentium 4
> 3.0GHz (I don't know witch P4)

Try cat /proc/cpuinfo.

> TESTS RESULTS
> ==============

On a dual-core Opteron 280 with 4G RAM with an LSI PCI-X Fusion-MPT
SAS controller, I am getting wildly uneven results:

tps = 264.775137 (excluding connections establishing)
tps = 160.365754 (excluding connections establishing)
tps = 151.967193 (excluding connections establishing)
tps = 148.010349 (excluding connections establishing)
tps = 260.973569 (excluding connections establishing)
tps = 144.693287 (excluding connections establishing)
tps = 148.147036 (excluding connections establishing)
tps = 259.485717 (excluding connections establishing)

I suspect the hardware's real maximum performance of the system is
~150 tps, but that the LSI's write cache is buffering the writes. I
would love to validate this hypothesis, but I'm not sure how.

Alexander.

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

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