Postgres Pro
Downloads
Home   >   mailing lists

Re: wrong rows and cost estimation when generic plan - Mailing list pgsql-performance

From David Rowley
Subject Re: wrong rows and cost estimation when generic plan
Date
Msg-id CAApHDvoUCEAVcsjAHBRAcjh2tFqd6Spi0EHcT__QhEAiWuJWmQ@mail.gmail.com
Whole thread Raw
In response to RE: wrong rows and cost estimation when generic plan  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List pgsql-performance
Tree view 
On Tue, 6 Dec 2022 at 20:17, James Pang (chaolpan) <chaolpan@cisco.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

pgsql-performance by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: RE: wrong rows and cost estimation when generic plan
Next
From: Jordan Hurwich
Date:
Subject: Increased iowait and blk_read_time with higher shared_buffers