Thread: Re: Bitmap scan cost model (was Re: bitmap scans, btree scans, and tid order)

Re: Bitmap scan cost model (was Re: bitmap scans, btree scans, and tid order)

From
"Zeugswetter Andreas DAZ SD"
Date:
> But to get the estimated cost ratio to match up with the actual cost
> ratio, we'd have to raise random_page_cost to nearly 70, which is a bit
> hard to credit.  What was the platform being tested here?

Why ? Numbers for modern single disks are 1-2Mb/s 8k random and 50-120 Mb/s
sequential.

Andreas