Re: Hardware for PostgreSQL

From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
To: Magnus Hagander <magnus(at)hagander(dot)net>
Cc: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>, Tomas Vondra <tv(at)fuzzy(dot)cz>, Ketema <ketema(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Hardware for PostgreSQL
Date: 2007-11-01 18:16:13
Message-ID: 472A17ED.1070008@pinpointresearch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Carlo Stonebanks 2007-11-01 20:57:34 How to avoid hashjoin and mergejoin
Previous Message Steve Crawford 2007-11-01 16:20:46 Re: Hardware for PostgreSQL