Re: Bitmap Heap scan 8.1/8.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Bitmap Heap scan 8.1/8.2
Date
Msg-id 4109.1193176377@sss.pgh.pa.us
Whole thread Raw
In response to Re: Bitmap Heap scan 8.1/8.2  (Martin Marques <martin@bugs.unl.edu.ar>)
List 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 by date:

Previous
From: Kevin Hunter
Date:
Subject: Re: data statistic functions
Next
From: Tom Lane
Date:
Subject: Re: data statistic functions