Postgres Pro
Downloads
Home   >   mailing lists

Re: Bogus nestloop join estimate, ignores WHERE clause - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Bogus nestloop join estimate, ignores WHERE clause
Date
Msg-id 3645.1314824359@sss.pgh.pa.us
Whole thread Raw
In response to Bogus nestloop join estimate, ignores WHERE clause  (Marti Raudsepp <marti@juffo.org>)
List pgsql-hackers
Tree view 
Marti Raudsepp <marti@juffo.org> writes:
> After a bit of digging, I figured out that it uses the same estimate
> as a semi-join WITHOUT the client_id restriction.
> ...
> For whatever reason, the 1st query completely ignores the fact that
> the client_id clause reduces the result count by a large factor.

Could we see the pg_stats rows for the two join columns?
        regards, tom lane

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [COMMITTERS] pgsql: Ensure that contrib/pgstattuple functions respond to cancel
Next
From: Oleg Bartunov
Date:
Subject: WIP: SP-GiST, Space-Partitioned GiST