Retrieving Alias Name

2019-02-26 Thread Walter Cai
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];

Re:

2018-01-09 Thread Walter Cai
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 <t...@sss.pgh.pa.us> wrote: > Walter Cai <wzca...@gmail

[no subject]

2018-01-09 Thread Walter Cai
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

Programmatically accessing selection predicates

2018-01-03 Thread Walter Cai
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

Accessing base table relational names via RelOptInfo

2017-12-06 Thread Walter Cai
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