Programmatically accessing selection predicates

Hi, In order to run some cardinality estimation experiments I'm hoping to access the raw values for selections predicates from within the calc_joinrel_size_estimate method (in costsize.c). If possible, I would very much appreciate the help. Best, Walter

Programmatically accessing selection predicates

Hi, In order to run some cardinality estimation experiments I'm hoping to access the raw values for selections predicates from within the calc_joinrel_size_estimate method (in costsize.c). For example, if the restriction WHERE name_attr = "example_str" appears in the query, I'd like to get the "

[no subject]

Hi, I (a graduate student) am currently trying to modify a postgres instance slightly to incorporate my modified cardinality estimates. In order to run these experiments I'm hoping to access the raw values for selections predicates from within the calc_joinrel_size_estimate method (in costsize.c).

Re:

Sorry about not including a title at first, I completely forgot! And thanks for the help, Tom. With respect to the Var: I'm really just hoping to access the column name Best, Walter On Tue, Jan 9, 2018 at 11:14 AM, Tom Lane wrote: > Walter Cai writes: > > I (a graduate student

Retrieving Alias Name

Hi, I'm currently using a (very rough) scheme to retrieve relation names from a PlannerInfo, and a RelOptInfo struct: PlannerInfo *root RelOptInfo *inner_rel //... RangeTblEntry *rte; int x = -1; while ((x = bms_next_member(inner_rel->relids, x)) >= 0) { rte = root->simple_rte_array[x];

Accessing base table relational names via RelOptInfo

Hi, I hope this is the appropriate list to send this to. *Context:* I (grad student) am trying to insert my own cardinality estimates into the optimizer *What I need to do to get there:* I want to be able to programmatically access the relation names inside from inside the calc_joinrel_size_es