public inbox for [email protected]  
help / color / mirror / Atom feed
From: Vanil Mar <[email protected]>
To: [email protected]
Subject: Simulator; only modified postgresql optimizer
Date: Tue, 21 May 2019 14:47:41 -0400
Message-ID: <CAOCuyinzTzQRcNzmrKbq=PC6nbKWDBwwfGfHL4EHJFGN3Ej9MA@mail.gmail.com> (raw)
In-Reply-To: <CAOCuyim4JT-ND0HQrdcDTb4juOXvTT6Wf5AF-cCKVfg2ZuFOCQ@mail.gmail.com>
References: <CAOCuyim4JT-ND0HQrdcDTb4juOXvTT6Wf5AF-cCKVfg2ZuFOCQ@mail.gmail.com>

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?


>


view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Simulator; only modified postgresql optimizer
  In-Reply-To: <CAOCuyinzTzQRcNzmrKbq=PC6nbKWDBwwfGfHL4EHJFGN3Ej9MA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox