In response to Bhaskar Sirohi : > 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 Not really. If you have enough money, you can divide your disk-space into 2 or 3 parts (separate disks and controllers) for data, indexes and WAL-logging, using tablespaces. But all depends on your workload (and the available money ...) Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
