Re: sustained update load of 1-2k/sec

Поиск
Список
Период
Сортировка
От Jeffrey W. Baker
Тема Re: sustained update load of 1-2k/sec
Дата
Msg-id 1124469284.29778.4.camel@toonses.gghcwest.com
обсуждение исходный текст
Ответ на Re: sustained update load of 1-2k/sec  (Ron <rjpeace@earthlink.net>)
Ответы Re: sustained update load of 1-2k/sec  (Ron <rjpeace@earthlink.net>)
Список pgsql-performance
On Fri, 2005-08-19 at 10:54 -0400, Ron wrote:
> Maxtor Atlas 15K II's.

> Areca's 1GB buffer RAID cards

The former are SCSI disks and the latter is an SATA controller.  The
combination would have a transaction rate of approximately 0.

I can vouch for the Areca controllers, however.  You can certainly
achieve pgbench transaction rates in the hundreds per second even with
only 5 7200RPM disks and 128MB cache.

Don't forget to buy the battery.

-jwb

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: LEFT JOIN ON vs. LEFT JOIN USING performance
Следующее
От: Jeremiah Jahn
Дата:
Сообщение: Re: extremly low memory usage