Postgres Pro
Downloads
Home   >   mailing lists

Re: strange nested loop row count estimates - Mailing list pgsql-general

From Tom Lane
Subject Re: strange nested loop row count estimates
Date
Msg-id 1474.1556771819@sss.pgh.pa.us
Whole thread Raw
In response to strange nested loop row count estimates  (Sergey Koposov <skoposov@cmu.edu>)
Responses Re: strange nested loop row count estimates
List pgsql-general
Tree view 
Sergey Koposov <skoposov@cmu.edu> writes:
> I'm currently trying to understand the expected row counts for a query involving a nested loop join and bitmap index
scan 
> on the functional index and a custom operator. And the numbers that I see don't make sense to me currently.

What sort of selectivity estimator have you got attached to that custom
operator?

            regards, tom lane

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Starting Postgres when there is no disk space
Next
From: Sergey Koposov
Date:
Subject: Re: strange nested loop row count estimates