Re: Hardware performance
Hannu Krosing <hannu@tm.ee>
From: Hannu Krosing <hannu@tm.ee>
To: Joe Conway <mail@joeconway.com>
Cc: pgsql-performance@postgresql.org
Date: 2003-07-17T07:56:49Z
Lists: pgsql-performance
Joe Conway kirjutas N, 17.07.2003 kell 07:52: > To an extent it depends on how big the drives are and how large you > expect the database to get. For maximal performance you want RAID 1+0 > for data and WAL; and you want OS, data, and WAL each on their own > drives. So with 5 drives one possible configuration is: > > 1 drive OS: OS on it's own drive makes it easy to upgrade, or restore > the OS from CD if needed > 2 drives, RAID 1+0: WAL > 2 drives, RAID 1+0: data How do you do RAID 1+0 with just two drives ? -------------- Hannu