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