Re: which dual-CPU hardware/OS is fastest for PostgreSQL? - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Date
Msg-id 1112043428.26232.43.camel@jd2.commandprompt.com
Whole thread Raw
In response to Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Greg Stark <gsstark@mit.edu>)
Responses Re: which dual-CPU hardware/OS is fastest for PostgreSQL?  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
> I assume AMCC == 3ware now?
>
> Has anyone verified that fsync is safe on these controllers? Ie, that they
> aren't caching writes and "lying" about the write completing like IDE
> drives often do by default?

The higher end AMCC/3ware controllers actually warn you about using
write-cache. You have to explicitly turn it on within the controller
bios.

They also have optional battery backed cache.

Sincerely,

Joshua D. Drake



>
--
Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source Authors: plPHP, pgManage, Co-Authors: plPerlNG
Reliable replication, Mammoth Replicator - http://www.commandprompt.com/


pgsql-performance by date:

Previous
From: Steve Poe
Date:
Subject: Re: which dual-CPU hardware/OS is fastest for PostgreSQL?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Preventing query from hogging server