On Tue, Jun 15, 2010 at 1:48 PM, Bhaskar Sirohi <bhaskar.sirohi@xxxxxxxxxx> wrote: > Hi All, > > We are right now in initial phase to setup a production server having > PostgreSQL database installed and would require help with Disk > configuration. The database size would grow approx to 500 GB. I have gone > through the following link > http://momjian.us/main/writings/pgsql/hw_performance/index.html which was > very helpful. However what I would like to understand is, do you have any > figures around minimum / optimal disk performance for postgresql to operate? > As an example I remember MS have a document on Exchange that gives some > rough guidance around the number of IOPS it needs depending on number of > users / mailbox size. Whether you need fast sequential throughput or fast random access, the best setup is usually to throw lots of drives at the problem. If you need multiple volumes to get lots of drives then use tablespaces to move busy tables to less busy drive sets. If you need lots of writes to happen all the time, then using a battery backed caching RAID controller or two or 8 is a necessity. So, IOPS is important for transactional stuff, but for report generation and things that tend to seq scan, throughput is more important. You tend to get good numbers either way with fast caching RAID controllers RAID-10. sometimes you can use software RAID and lots of disks for report servers with good results, but if the write load even blips up (like when loading data) they can slow to a crawl real fast. Note that software RAID can benefit greatly from a hardware caching controller in JBOD (just a bunch of disks) mode and offloads some small amount of work from the RAID controller to a cpu. So, what are you doing with your DB, model wise? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
