Re: Regarding query minimizer (simplifier)

2018-10-23 Thread Jinho Jung
*Order is reversed. * *1.sql* 9.4.19: 20ms 10.5 : 1,227ms *4.sql* 9.4.19: 13ms 10.5 : 88,721ms *20.sql* 9.4.19: 271ms 10.5 : 6,104ms *22.sql* 9.4.19: 8ms 10.5 : 105ms On Tue, Oct 23, 2018 at 3:15 PM Jinho Jung wrote: > Hello, > > We appreciate you taking time for test! W

Re: Regarding query minimizer (simplifier)

2018-10-23 Thread Jinho Jung
* 10.5 : 8ms 9.4.19: 105ms Jinho Jung On Tue, Oct 23, 2018 at 9:52 AM Jung, Jinho wrote: > > Hello Tom, > > > Sorry for the misleading. Could you try these two queries? I made the > query even slower in latest version of postgres. These are information > about how

Question regarding SQL-query minimizer

2018-10-10 Thread Jinho Jung
unnecessary part (i.e., minimize the size of SQL unless it contains same problem), do you use any tool? Thanks, Jinho Jung