2016-01-12 17:01 GMT+01:00 Vladimir Sitnikov <sitnikov.vladi...@gmail.com>:
> VS>>Why doesn't backend reuse already existing good plan? > PS>this logic is driven by plan cost, not by plan execution time. > > It do understand that currently PG replans with $1, $2 and uses > default selectivities for that. > > What I am asking is to make PG aware of "previously used bind values", > so it would calculate proper selectivities for $1, $2. > the implementation is simply - but it hard to design some really general - it is task for UI Pavel > > PS. It is not the first time the problem bites me, so I hand-crafted a > testcase. > > > Vladimir >