Re: [PERFORM] very very slow inserts into very large table

2012-07-16 Thread Satoshi Nagayasu
Xeon E5430 @ 2.66GHz with 32GB of RAM and a 3ware 9690 RAID 4TB RAID10 for the storage for What might be going on here? -- Satoshi Nagayasu Uptime Technologies, LLC. http://www.uptime.jp -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your

Re: [PERFORM] Postgresql 9.0.6 Raid 5 or not please help.

2011-12-22 Thread Satoshi Nagayasu
Hi, In addition, when you have multiple hard drive, it needs to be considered to put a database cluster and wal files separately on different spindles (hard drives), because of different I/O charasteristics, in particular update intensive workload. Generally speaking, having 4 disks, one RAID-