Re: postgresql 8.3 tps rate

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: postgresql 8.3 tps rate
Дата
Msg-id b42b73150901230651j50365334u2794c9bfdfc69027@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgresql 8.3 tps rate  (Ibrahim Harrani <ibrahim.harrani@gmail.com>)
Ответы Re: postgresql 8.3 tps rate  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-performance
On 1/23/09, Ibrahim Harrani <ibrahim.harrani@gmail.com> wrote:
> Hi Craig,
>
>  Here is the result. It seems that disk write is terrible!.
>
>  root@myserver /usr]#  time (dd if=/dev/zero of=bigfile bs=8192
>  count=1000000; sync)

Note, while sequential write speeds are a good indication of general
raid crappyness, they are not the main driver of your low pgbench
results (buy they may be involved with poor insert performance)

That is coming from your seek performance, which is also lousy at ~130
according to bonnie.

merlin

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

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: SSD performance
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: SSD performance