2016-09-12 12:08 GMT-03:00 Oleksandr Shulgin <oleksandr.shul...@zalando.de>:
> On Mon, Sep 12, 2016 at 4:03 PM, Vinicius Segalin <vinisega...@gmail.com> > wrote: > >> Hi everyone, >> >> I'm trying to find a way to predict query runtime (I don't need to be >> extremely precise). I've been reading some papers about it, and people are >> using machine learning to do so. For the feature vector, they use what the >> DBMS's query planner provide, such as operators and their cost. The thing >> is that I haven't found any work using PostgreSQL, so I'm struggling to >> adapt it. >> My question is if anyone is aware of a work that uses machine learning >> and PostgreSQL to predict query runtime, or maybe some other method to >> perform this. >> > > Hi, > > I'm not aware of machine-learning techniques to achieve that (and I don't > actually believe it's feasible), but there you might find this extension > particularly useful: https://www.postgresql.org/docs/9.5/static/ > pgstatstatements.html > I'll read about it and see how it can help me. Thank you > Can you share some links to the papers you are referring to (assuming > these are publicly available)? > I don't have them all now, but these are some of them: http://dl.acm.org/citation.cfm?id=1845166 https://people.eecs.berkeley.edu/~jordan/papers/ganapathi-etal-icde09.pdf
