Re: Hardware for PostgreSQL - Mailing list pgsql-performance

From Ow Mun Heng
Subject Re: Hardware for PostgreSQL
Date
Msg-id 1193963214.9625.3.camel@neuromancer.home.net
Whole thread Raw
In response to Re: Hardware for PostgreSQL  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-performance
On Thu, 2007-11-01 at 11:16 -0700, Steve Crawford wrote:
> Magnus Hagander wrote:
> > Ow Mun Heng wrote:
> >>> You're likely better off (performance-wise) putting it on the same disk
> >>> as the database itself if that one has better RAID, for example.
> >> I'm thinking along the lines of since nothing much writes to the OS
> >> Disk, I should(keyword) be safe.
> >
> > Unless it's *always* in the cache (not so likely), reads will also move
> > the heads...
>
> And if you aren't mounted noatime, reads will also cause a write.


/dev/VolGroup00/LogVol01 /                       ext3    defaults,noatime        1 1
/dev/md0                /raid1_array            ext3    noatime,data=writeback   1 1

Yep..yep..

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to avoid hashjoin and mergejoin
Next
From: Mark Floyd
Date:
Subject: hardware for PostgreSQL