From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | "Benjamin Wragg" <bwragg(at)tpg(dot)com(dot)au> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Disk configuration |
Date: | 2005-01-18 22:49:21 |
Message-ID: | 200501181449.21224.josh@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Schroeder | 2005-01-18 22:49:35 | Swapping on Solaris |
Previous Message | Benjamin Wragg | 2005-01-18 22:03:44 | Disk configuration |