Re: FW:

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: FW:
Дата
Msg-id 87d51ai5zg.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: FW:  (david@lang.hm)
Список pgsql-performance
<david@lang.hm> writes:

> with a standard 7200 rpm drive ~150 transactions/sec sounds about right
>
> to really speed things up you want to get a disk controller with a battery
> backed cache so that the writes don't need to hit the disk to be safe.

Note that this is only if you're counting transactions/sec in a single
session. You can get much more if you have many sessions since they can all
commit together in a single disk i/o.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


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

Предыдущее
От: Gregory Stark
Дата:
Сообщение: Re: What's The Difference Between VACUUM and VACUUM ANALYZE?
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Nested loops overpriced