Re: strange nested loop row count estimates

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergey Koposov <skoposov(at)cmu(dot)edu>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: strange nested loop row count estimates
Date: 2019-05-02 04:36:59
Message-ID: 1474.1556771819@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sergey Koposov <skoposov(at)cmu(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sergey Koposov 2019-05-02 04:49:25 Re: strange nested loop row count estimates
Previous Message Ron 2019-05-02 04:01:22 Re: Starting Postgres when there is no disk space