On Thu, Apr 26, 2012 at 2:37 PM, Claudio Freire <klaussfreire(at)gmail(dot)com> wrote:
> Fun thing is, nothing in the CTE's execution really changed. The only
> change, is that now a sequential scan of overview was chosen instead
> of the index.
> Why could this be? The output (number of search values, even the
> values themselves and their order) is the same between both plans.
I just noticed it's misestimating the output of the union distinct,
but not of the select distinct.
One would expect the estimation procedure to be the same in both cases.
Any reason for the difference? Any way to "teach" pg about it?