Re: Hardware for PostgreSQL

[Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>]

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..