> 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 Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to