Re: Hardware for PostgreSQL - Mailing list pgsql-performance

From Steve Crawford
Subject Re: Hardware for PostgreSQL
Date
Msg-id 472A17ED.1070008@pinpointresearch.com
Whole thread Raw
In response to Re: Hardware for PostgreSQL  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Hardware for PostgreSQL
List pgsql-performance
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.

Cheers,
Steve

pgsql-performance by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Hardware for PostgreSQL
Next
From: "Carlo Stonebanks"
Date:
Subject: How to avoid hashjoin and mergejoin