Re: strange estimate for number of rows

On Thu, Nov 13, 2003 at 04:37:03PM -0500, Andrew Sullivan wrote:
> Actually, this one's on an internal box, and I think 1.5 is too low
> -- it's really just a pair of mirrored SCSI disks on a PCI controller
> in this case. That does the trick, though, so maybe I'm just being
> too conservantive.

I spoke too soon. I'd left enable_seqscan=off set. It doesn't
actually prefer an indexscan until I set the random_page_cost to .5.
I think that's a little unrealistic ;-)

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110