Re: BUG #14438: Wrong row count in the join plan with unique index scan - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #14438: Wrong row count in the join plan with unique index scan
Date
Msg-id 11935.1480460865@sss.pgh.pa.us
Whole thread Raw
In response to BUG #14438: Wrong row count in the join plan with unique index scan  (nikolay.nikitin@infowatch.com)
Responses Re: BUG #14438: Wrong row count in the join plan with unique index scan
List pgsql-bugs
nikolay.nikitin@infowatch.com writes:
> I execute select with "in" condition on the empty table.
> This select works with wrong plan.
> I think the wrong plan is chosen becose the postgres optimizer incorrectly
> calculates row count in the right plan.

I've pushed a patch that should improve matters for such cases.
Thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Michael Day
Date:
Subject: Re: parallel sequential scan returns extraneous rows
Next
From: djlopes@gmail.com
Date:
Subject: BUG #14440: Error starting postgres