Re: Regression from 9.4-9.6

Jim Nasby <jim(at)nasby(dot)net> writes:
> I've got a query that's regressed from 9.4 to 9.6. I suspect it has
> something to do with the work done around bad plans from single-row
> estimates.

Why has this indexscan's cost estimate changed so much?

>> -> Index Scan using bdata_filed_departuretime on bdata_forks (cost=0.57..50807.51 rows=1 width=36) (actual time=979.381..3207.777 rows=508 loops=1)

>> -> Index Scan using bdata_filed_departuretime on bdata_forks (cost=0.57..14894236.06 rows=1 width=36) (actual time=892.664..3025.653 rows=508 loops=1)

I think the reason it's discarding the preferable plan is that, with this
huge increment in the estimated cost getting added to both alternatives,
the two nestloop plans have fuzzily the same total cost, and it's picking
the one you don't want on the basis of some secondary criterion.

regards, tom lane