Re: [PERFORM] anti-join with small table via text/varchar cannot estimate rows correctly

[David G. Johnston]

On Wed, Mar 1, 2017 at 3:00 PM, Stefan Andreatta <s.andrea...@synedra.com>
wrote:

> plain analyze
>      select tmp_san_1.id
>      from tmp_san_1
>        left join tmp_san_2 on tmp_san_1.text = tmp_san_2.text
>      where tmp_san_2.id is null;
>
> ​Does it help if you check for "tmp_san_2.text is null"?

David J.