Re: strange estimate for number of rows - Mailing list pgsql-performance

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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110