On Sun, 2006-12-10 at 14:57 -0500, Tom Lane wrote:
> Comments in general?  I'm a bit worried that these changes will bias
> us
> against indexscans too much, but there's no sign of that in Arjen's
> results. 

Are Arjen's tests on prepared queries? Does that change anything? We shy
away from indexes on prepared queries too much already, important when
the consequence of doing so is an O(N) seqscan rather than an O(logN)

The cost of initiating an index scan is a cause for concern, but it
seems reasonable to get it accurate. I'd like to perform some of that
work at planning time, not at scan time, when it is possible for us to
do so. Simple indexed, planned queries shouldn't need to pay that cost

  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to