On Wed, 2005-05-18 at 11:27 -0400, Tom Lane wrote:
> "Jeffrey W. Baker" <[EMAIL PROTECTED]> writes:
> > Obviously in this case sequential scan was (would have been) a huge win.
> > Incrementing random_page_cost from 4 (the default) to 5 causes the
> > planner to make a better decision.
>
> 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?
i686 Linux 2.6.8 with a single 7200RPM SATA disk.
-jwb
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
