Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly - Mailing list pgsql-performance

From David G. Johnston
Subject Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly
Date
Msg-id CAKFQuwaK=HhqMRL-C8no7YT5ASFJJwe+CVgPrer3V52ih3Z-xw@mail.gmail.com
Whole thread Raw
In response to [PERFORM] anti-join with small table via text/varchar cannot estimate rowscorrectly  (Stefan Andreatta <s.andreatta@synedra.com>)
Responses Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly
List pgsql-performance
Tree view
On Wed, Mar 1, 2017 at 3:00 PM, Stefan Andreatta <s.andreatta@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.

pgsql-performance by date:

Previous
From: Stefan Andreatta
Date:
Subject: [PERFORM] anti-join with small table via text/varchar cannot estimate rowscorrectly
Next
From: Jeff Janes
Date:
Subject: Re: [PERFORM] anti-join with small table via text/varchar cannotestimate rows correctly