Postgres Pro
Downloads
Home   >   mailing lists

Re: BETWEEN optimizer problems with single-value - Mailing list pgsql-performance

From Simon Riggs
Subject Re: BETWEEN optimizer problems with single-value
Date
Msg-id 1142467626.3859.207.camel@localhost.localdomain
Whole thread Raw
In response to Re: BETWEEN optimizer problems with single-value  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: BETWEEN optimizer problems with single-value  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Tree view 
On Wed, 2006-03-15 at 14:17 -0500, Tom Lane wrote:

> It looks to me like this is a matter of bad cost estimation, ie, it's
> thinking the other index is cheaper to use.  Why that is is not clear.
> Can we see the pg_stats rows for ctofcNo and calDate?

ISTM that when the BETWEEN constants match we end up in this part of
clauselist_selectivity()...

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: [HACKERS] BETWEEN optimizer problems with single-value
Next
From: Simon Riggs
Date:
Subject: Re: BETWEEN optimizer problems with single-value