Re: wrong rows and cost estimation when generic plan

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>, "jamespang886(at)gmail(dot)com" <jamespang886(at)gmail(dot)com>
Subject: Re: wrong rows and cost estimation when generic plan
Date: 2022-12-06 09:04:21
Message-ID: CAApHDvoUCEAVcsjAHBRAcjh2tFqd6Spi0EHcT__QhEAiWuJWmQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 6 Dec 2022 at 20:17, James Pang (chaolpan) <chaolpan(at)cisco(dot)com> wrote:
> Could you provide the function name for generic plan selectivity estimation?

If you look at eqsel_internal(), you'll see there are two functions
that it'll call var_eq_const() for Consts and otherwise
var_eq_non_const(). It'll take the non-Const path for planning generic
plans.

David

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jordan Hurwich 2022-12-13 00:29:05 Increased iowait and blk_read_time with higher shared_buffers
Previous Message James Pang (chaolpan) 2022-12-06 07:16:55 RE: wrong rows and cost estimation when generic plan