On 13-Feb-08, at 5:02 AM, Tore Halset wrote:
Hello.
I think I started that discussion. We ended up buying a Dell 2900
with PERC 6/i and 10 * 145GB SAS 3,5" 15KRpm discs. 6 of the SAS
discs are in a raid 10 for the database, 2 in a mirror for the wal
and the last 2 in a mirror for the OS. We get 350MB/s writing and
380MB/s reading to/from the raid 10 area using dd. The OS is Ubuntu
and the filesystem for the raid 10 is ext3.
Wow that's fantastic. Just to be sure, did you make sure that you read
and wrote 2x memory to take the cache out of the measurement ?
Dave
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
