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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wed, Mar 1, 2017 at 3:00 PM, Stefan Andreatta <s.andreatta@xxxxxxxxxxx> 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.