Two hard drives --- what to do with them?
От | Carlos Moreno |
---|---|
Тема | Two hard drives --- what to do with them? |
Дата | |
Msg-id | 45E104DD.3080600@mochima.com обсуждение исходный текст |
Ответ на | Re: which Xeon processors don't have the context switching problem ("Joshua D. Drake" <jd@commandprompt.com>) |
Ответы |
Re: Two hard drives --- what to do with them?
Re: Two hard drives --- what to do with them? |
Список | pgsql-performance |
Say that I have a dual-core processor (AMD64), with, say, 2GB of memory to run PostgreSQL 8.2.3 on Fedora Core X. I have the option to put two hard disks (SATA2, most likely); I'm wondering what would be the optimal configuration from the point of view of performance. I do have the option to configure it in RAID-0, but I'm sort of reluctant; I think there's the possibility that having two filesystems that can be accessed truly simultaneously can be more beneficial. The question is: does PostgreSQL have separate, independent areas that require storage such that performance would be noticeably boosted if the multiple storage operations could be done simultaneously? Notice that even with RAID-0, the "twice the performance" may turn into an illusion --- if the system requires access from "distant" areas of the disk ("distant" as in many tracks apart), then the back-and-forth travelling of the heads would take precedence over the doubled access speed ... Though maybe it depends on whether accesses are in small chunks (in which case the cache of the hard disks could take precedence). Coming back to the option of two independent disks --- the thing is: if it turns out that two independent disks are a better option, how should I configure the system and the mount points? And how would I configure PostgreSQL to take advantage of that? Advice, anyone? Thanks, Carlos --
В списке pgsql-performance по дате отправления: