Benjamin, > I just wanted to bounce off the list the best way to configure disks for a > postgresql server. My gut feeling is as follows: > > Keep the OS and postgresql install on seperate disks to the postgresql > /data directory? > Is a single hard disk drive acceptable for the OS and postgresql program, > or will this create a bottle neck? Would a multi disk array be more > appropriate?
All of this depends heavily on your database size, read/write balance, and transaction volume. For example, the PostgreSQL Press list runs fine on my single-drive IDE laptop (1 user, < 2mb database) but I wouldn't run the DBT2 (high-volume OLTP test) on it. More info? -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend