On 26/01/2010 8:58 AM, yua ゅぁ wrote: > RAID Card : LSI MegaRAID > Battery Cache : YES > write-back Cache : NO > Software RAID : NO ( Hardware RAID)
The LSI MegaRAID series are, AFAIK, software raid implementations. The hardware has some BIOS hooks to enable boot-loading, then the OS loads a driver that does all the real work for the RAID implementation. ... though a quick Google search suggests they may be using that brand for real RAID hardware too, so without specifying the model number it's hard to know what your RAID hardware is. The fact that your card has a BBU tends to confirm they're making real RAID hardware under that name. It probably doesn't make much difference in this particular case, though, as disk I/O is unlikely to be part of your issue. > SAN : NO > Disk : 7,200rpm SATA 3lot > Disk : RAID5 3slot Again it's not the cause of the problem you report, but: Most databases, and certainly PostgreSQL, perform poorly on RAID 5. In particular, PostgreSQL really doesn't like having the WAL stored on RAID 5, but really you're much better off using RAID 10 for all your database-related storage if you can. -- Craig Ringer -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
