Re: Sustained inserts per sec ... ?

Поиск
Список
Период
Сортировка
От Alex Turner
Тема Re: Sustained inserts per sec ... ?
Дата
Msg-id 33c6269f05040407471d716702@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Sustained inserts per sec ... ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Yup, Battery backed, cache enabled.  6 drive RAID 10, and 4 drive RAID
10, and 2xRAID 1.

It's a 3ware 9500S-8MI - not bad for $450 plus BBU.

Alex Turner
netEconomist

On Apr 1, 2005 6:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Alex Turner <armtuk@gmail.com> writes:
> > On Apr 1, 2005 4:17 PM, Alex Turner <armtuk@gmail.com> wrote:
> >> 1250/sec with record size average is 26 bytes
> >> 800/sec with record size average is 48 bytes.
> >> 250/sec with record size average is 618 bytes.
>
> > Oh - this is with a seperate transaction per command.
> > fsync is on.
>
> [ raised eyebrow... ]  What kind of disk hardware is that exactly, and
> does it have write cache enabled?  It's hard to believe those numbers
> if not.
>
> Write caching is fine if it's done in a battery-backed cache, which you
> can get in the higher-end hardware RAID controllers.  Otherwise you're
> going to have problems whenever the power goes away unexpectedly.
>
>                         regards, tom lane
>

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

Предыдущее
От: Christopher Petrilli
Дата:
Сообщение: Re: Sustained inserts per sec ... ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 8.0.1 performance question.