Re: Best OS & Configuration for Dual Xeon w/4GB &

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: Best OS & Configuration for Dual Xeon w/4GB &
Дата
Msg-id 20060321175900.GH15742@pervasive.com
обсуждение исходный текст
Ответ на Re: Best OS & Configuration for Dual Xeon w/4GB &  ("Luke Lonergan" <llonergan@greenplum.com>)
Ответы Re: Best OS & Configuration for Dual Xeon w/4GB &
Список pgsql-performance
On Tue, Mar 21, 2006 at 07:25:07AM -0800, Luke Lonergan wrote:
> Jim,
>
> On 3/21/06 3:49 AM, "Jim C. Nasby" <jnasby@pervasive.com> wrote:
>
> > No, I don't know why the transfer rates for the mirror are 1/2 that as the raw
> > device. :(
>
> Well - lessee.  Would those drives be attached to a Silicon Image (SII) SATA
> controller?  A Highpoint?
>
> I found in testing about 2 years ago that under Linux (looks like you're
> BSD), most SATA controllers other than the Intel PIIX are horribly broken
> from a performance standpoint, probably due to bad drivers but I'm not sure.
>
> Now I think whatever is commonly used by Nforce 4 implementations seems to
> work ok, but we don't count on them for RAID configurations yet.

atapci1: <nVidia nForce4 SATA150 controller>

And note that this is using FreeBSD gmirror, not the built-in raid
controller.
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: planner with index scan cost way off actual cost,
Следующее
От: Fernando Lujan
Дата:
Сообщение: Sequence Scan vs. Index scan