| From: | Rajmohan C <csrajmohan(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to modify parser in PostgreSQL to handle new keyword and parse it |
| Date: | 2014-08-14 16:39:09 |
| Message-ID: | CAHaqV0gZ_C9iqsHaDfQQxc2HxwaeYWjCesFVHK1-AMJA9xkMKg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am working on implementing Selectivity hints feature in PostgreSQL 9.3.4.
I am working on this only for using it in my academic research. I have
decided to give selectivity information per relation as part of query like
shown below.
select * from lineitem, orders where l_extendedprice <=2400 and l_orderkey
= o_orderkey selectivity(lineitem, 0.3) selectivity(orders, 0.7);
I tried separating the selectivity hint portion of the query before
Postgres parses query. But it becomes very clumsy. I am thinking Postgres
parser modification to handle this case could be complex that is why I did
not get into Postgres grammar and parser. How should I take this
selectivity hints separate from a normal query and populate in my data
structures?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Mitchell | 2014-08-14 17:53:15 | Re: Best practices for cloning DB servers |
| Previous Message | Tom Lane | 2014-08-14 16:23:53 | Re: is there a way log last query in pg_stat_activity |