Re: Bitmap Heap scan 8.1/8.2

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bitmap Heap scan 8.1/8.2
Дата
Msg-id 4109.1193176377@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bitmap Heap scan 8.1/8.2  (Martin Marques <martin@bugs.unl.edu.ar>)
Список pgsql-general
Martin Marques <martin@bugs.unl.edu.ar> writes:
> Ok, now the 8.1 server has a RAID1 hardware board with SCSI disks, and
> the 8.2 is just a PentiumD with SATA disks (it's my desktop PC where I
> do tests). Should I have a lower random_page_cost on a machine that is
> likely to have a lower disk IO speed?

I'd guess the other way round: cheaper disks are likely to have worse
seek speeds, which translates to random accesses being proportionally
slower.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Kevin Hunter
Дата:
Сообщение: Re: data statistic functions
Следующее
От: Tom Lane
Дата:
Сообщение: Re: data statistic functions