On 28.07.2007 06:48, Jean-Denis Girard wrote:
The NAS would be from LaCie, using 4 disks (Raid5 + spare)
(http://www.lacie.com/fr/products/product.htm?pid=10876), mounted via
NFS from a Linux server running Postgresql .
Sorry, but that sounds like a sick setup..
1.) RAID 5 is a bad choice for a DBMS, due to implicit reads caused by
parity calculation.
2.) Most cheap NAS (such as this one) have way to high latency for a DBMS.
3.) NFS is nothing you want to have a DBMS running on top.
4.) I don't think this device has battery backed cache.
5.) At least I have bad experiences with Lacie storage devices (Bigger
Disk Extreme)
To sum it up.. I'd say what you get with that setup is a dead slow,
unstable PostgreSQL experience with a good chance of data corruption on
power failure.
--
Regards,
Hannes Dorbath
---------------------------(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
