Postgres Pro
Downloads
Home   >   mailing lists

Re: Best hardware/cost tradoff? - Mailing list pgsql-performance

From cluster
Subject Re: Best hardware/cost tradoff?
Date
Msg-id g9b6v7$1ujm$1@news.hub.org
Whole thread Raw
In response to Re: Best hardware/cost tradoff?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Best hardware/cost tradoff?  ("Fernando Hevia" <fhevia@ip-tel.com.ar>)
List pgsql-performance
Tree view 
We are now leaning towards just buying 4 SAS disks.

So should I just make one large RAID-10 partition or make two RAID-1's
having the log on one RAID and everything else on the second RAID?
How can I get the best read/write performance out of these four disks?
(Remember, that it is a combined web-/database server).

pgsql-performance by date:

Previous
From: "Gregory S. Youngblood"
Date:
Subject: Re: select on 22 GB table causes "An I/O error occured while sending to the backend." exception
Next
From: Thomas Finneid
Date:
Subject: slow update of index during insert/copy