Re: Hardware for PostgreSQL

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: Hardware for PostgreSQL
Дата
Msg-id 472A17ED.1070008@pinpointresearch.com
обсуждение исходный текст
Ответ на Re: Hardware for PostgreSQL  (Magnus Hagander <magnus@hagander.net>)
Ответы Re: Hardware for PostgreSQL
Список 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 по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: Hardware for PostgreSQL
Следующее
От: "Carlo Stonebanks"
Дата:
Сообщение: How to avoid hashjoin and mergejoin