Re: [GENERAL] Query generator

2016-10-16 Thread Vinicius Segalin
2016-10-16 8:54 GMT-02:00 Andreas Seltenreich : > Vinicius Segalin writes: > > > 2016-09-29 16:32 GMT-03:00 Julien Rouhaud : > > > > > You should try sqlsmith (https://github.com/anse1/sqlsmith), which > works > > > very well. > > > > I

Re: [GENERAL] Query generator

2016-09-29 Thread Vinicius Segalin
2016-09-29 16:32 GMT-03:00 Julien Rouhaud : > On 29/09/2016 21:27, Vinicius Segalin wrote: > > Hi everyone, > > > > Hello, > > > Does anyone know a random query generator for Postgres? Something that > > gets my schema and, based on that, generates hundred

[GENERAL] Query generator

2016-09-29 Thread Vinicius Segalin
Hi everyone, Does anyone know a random query generator for Postgres? Something that gets my schema and, based on that, generates hundreds of different queries with join, group by, etc. Thank you.

Re: [GENERAL] Predicting query runtime

2016-09-14 Thread Vinicius Segalin
2016-09-14 7:23 GMT-03:00 Oleg Ivanov : > > > I hope listed papers will be useful for your master's thesis. > > I'm sure they will! Thank you, Oleg.

Re: [GENERAL] Predicting query runtime

2016-09-13 Thread Vinicius Segalin
2016-09-13 17:12 GMT-03:00 Oleg Bartunov : > > > FYI, please check https://pgconf.ru/2016/89977 > > Interesting! Was this presentation filmed? Or would you have a post or something else with more details?

Re: [GENERAL] Predicting query runtime

2016-09-12 Thread Vinicius Segalin
2016-09-12 18:22 GMT-03:00 Istvan Soos : > Hi Vinicius, > > At Heap we have non-trivial complexity in our analytical queries, and > some of them can take a long time to complete. We did analyze features > like the query planner's output, our query properties (type, > parameters, complexity) and tr

Re: [GENERAL] Predicting query runtime

2016-09-12 Thread Vinicius Segalin
2016-09-12 17:01 GMT-03:00 Jeff Janes : > On Mon, Sep 12, 2016 at 7:03 AM, Vinicius Segalin > 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

Re: [GENERAL] Predicting query runtime

2016-09-12 Thread Vinicius Segalin
2016-09-12 15:16 GMT-03:00 Merlin Moncure : > On Mon, Sep 12, 2016 at 9:03 AM, Vinicius Segalin > 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 som

Re: [GENERAL] Predicting query runtime

2016-09-12 Thread Vinicius Segalin
2016-09-12 12:08 GMT-03:00 Oleksandr Shulgin : > On Mon, Sep 12, 2016 at 4:03 PM, Vinicius Segalin > 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

[GENERAL] Predicting query runtime

2016-09-12 Thread Vinicius Segalin
ators 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. Thank you. Best regards, Vinicius Segalin