Simulator; only modified postgresql optimizer

--0000000000002996d105896a49a3
Content-Type: text/plain; charset="UTF-8"

Hi,



There was a project done over Postgresql 9.1.1 - it is a preference aware
query optimizer. It consists of modified parser(which provides the users
with an option for additional parser syntax) and modified optimizer(early
prunning, additional cost metric). It is generating optimized plan.


 My task now is to migrate only the modified optimizer and develop it
further on 10.4. This means that I will have to input directly a parser
tree to the optimizer module and output the new tree generated by the
optimizer.


How can I efficiently approach such a simulator? I mean, I will need only
to provide specific trees to the optimizer module and return results, not
to  develop a whole new version of postgresql dbms. In general, when I was
developing over the whole postgresql it was fine as I can create a db in
the regular dbms and then just compile the modified files and start it
again over the already created database. Now I am really not sure what
should be the right and smart approach.



Can you share any advice/information/links/articles, please?


>

--0000000000002996d105896a49a3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><blockquote type=3D"cite" style=3D"color:=
rgb(80,0,80)"><div dir=3D"ltr"><p class=3D"MsoNormal" style=3D"margin:0in 0=
in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">Hi,</p><p class=
=3D"MsoNormal" style=3D"margin:0in 0in 0.0001pt;font-size:11pt;font-family:=
Calibri,sans-serif">=C2=A0</p><p class=3D"MsoNormal" style=3D"margin:0in 0i=
n 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">There was a proje=
ct done over Postgresql 9.1.1 - it is a preference aware query optimizer. I=
t consists of modified parser(which provides the users with an option for a=
dditional parser syntax) and modified optimizer(early prunning, additional =
cost metric). It is generating optimized plan.</p><p class=3D"MsoNormal" st=
yle=3D"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-seri=
f"><br></p><p class=3D"MsoNormal" style=3D"margin:0in 0in 0.0001pt;font-siz=
e:11pt;font-family:Calibri,sans-serif">=C2=A0My task now is to migrate only=
 the modified optimizer and develop it further on 10.4. This means that I w=
ill have to input directly a parser tree to the optimizer module and output=
 the new tree generated by the optimizer.=C2=A0</p><p class=3D"MsoNormal" s=
tyle=3D"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-ser=
if"><br></p><p class=3D"MsoNormal" style=3D"margin:0in 0in 0.0001pt;font-si=
ze:11pt;font-family:Calibri,sans-serif">How can I efficiently approach such=
 a simulator? I mean, I will need only to provide specific trees to the opt=
imizer module and return results, not to=C2=A0 develop a whole new version =
of postgresql dbms. In general, when I was developing over the whole postgr=
esql it was fine as I can create a db in the regular dbms and then just com=
pile the modified files and start it again over the already created databas=
e. Now I am really not sure what should be the right and smart approach.=C2=
=A0</p><p class=3D"MsoNormal" style=3D"margin:0in 0in 0.0001pt;font-size:11=
pt;font-family:Calibri,sans-serif">=C2=A0</p><p class=3D"MsoNormal" style=
=3D"margin:0in 0in 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">=
Can you share any advice/information/links/articles, please?=C2=A0</p></div=
></blockquote></div><div class=3D"gmail_quote"><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><br>
</blockquote></div></div>

--0000000000002996d105896a49a3--