Re: Server Performance

Поиск
Список
Период
Сортировка
От Greg Smith
Тема Re: Server Performance
Дата
Msg-id alpine.GSO.2.01.0903311638390.8042@westnet.com
обсуждение исходный текст
Ответ на Server Performance  (Chris.Ellis@shropshire.gov.uk)
Список pgsql-general
On Tue, 31 Mar 2009, Chris.Ellis@shropshire.gov.uk wrote:

> Been having interesting times with an IBM x3650 with 8 15k RPM 73GB
> drives in RAID 10 and a ServRAID 8K controller with Write-Back cache
> enabled (battery installed and working).  Currently getting a pgbench
> score of 4.7 transactions per second!

pgbench is a very high level test of your system.  It can tell you when a
system is doing well, but it's almost useless for figuring out what's
wrong if there's a problem.

You shouldn't run pgbench until you've first done a lower-level benchmark
such as bonnie++ on the hardware.  That should give you a better idea
what's going on here, and if the badness shows up there it will be much
easier to get someone at IBM to pay attention too.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

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

Предыдущее
От: Laurent Rahuel
Дата:
Сообщение: Triggers for a MPTT based table
Следующее
От: Patrick Desjardins
Дата:
Сообщение: ERROR: XX001: could not read block 2354 of relation…