Re: Hardware for PostgreSQL

Поиск
Список
Период
Сортировка
От Ow Mun Heng
Тема Re: Hardware for PostgreSQL
Дата
Msg-id 1193963214.9625.3.camel@neuromancer.home.net
обсуждение исходный текст
Ответ на Re: Hardware for PostgreSQL  (Steve Crawford <scrawford@pinpointresearch.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: How to avoid hashjoin and mergejoin
Следующее
От: Mark Floyd
Дата:
Сообщение: hardware for PostgreSQL