Re: Disk configuration

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

In response to

Browse pgsql-performance by date

  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