Re: SSD + RAID
От | Craig James |
---|---|
Тема | Re: SSD + RAID |
Дата | |
Msg-id | 4B005C32.3090509@emolecules.com обсуждение исходный текст |
Ответ на | Re: SSD + RAID (Craig Ringer <craig@postnewspapers.com.au>) |
Ответы |
Re: SSD + RAID
|
Список | pgsql-performance |
I've wondered whether this would work for a read-mostly application: Buy a big RAM machine, like 64GB, with a crappy littlesingle disk. Build the database, then make a really big RAM disk, big enough to hold the DB and the WAL. Then builda duplicate DB on another machine with a decent disk (maybe a 4-disk RAID10), and turn on WAL logging. The system would be blazingly fast, and you'd just have to be sure before you shut it off to shut down Postgres and copythe RAM files back to the regular disk. And if you didn't, you could always recover from the backup. Since it's a read-mostlysystem, the WAL logging bandwidth wouldn't be too high, so even a modest machine would be able to keep up. Any thoughts? Craig
В списке pgsql-performance по дате отправления: