Re: [GENERAL] 9.6 Beta 2 Performance Regression on Recursive CTE

2016-07-05 Thread Tom Lane
"Nicholson, Brad (Toronto, ON, CA)" writes: > I'm seeing a performance regression on 9.6 Beta 2 compared to 9.5.3. > The query is question is a recursive query on graph data stored as an > adjacency list. FWIW, I can't reproduce any regression with this example. I get EXPLAIN execution times lik

[GENERAL] 9.6 Beta 2 Performance Regression on Recursive CTE

2016-07-04 Thread Nicholson, Brad (Toronto, ON, CA)
Hi, I'm seeing a performance regression on 9.6 Beta 2 compared to 9.5.3. The query is question is a recursive query on graph data stored as an adjacency list. While this is example is fairly contrived, it mimics the behavior I am seeing on real data with more realistic queries. The example b