Re: [GENERAL] Joining against a view that uses an aggregate - performance issue

2013-03-11 Thread Joe Van Dyk
Here's a much smaller self-contained example of the problem: https://gist.github.com/joevandyk/06e1e26219726f11917e/raw/e9b279c2f2776d5825a6adbb04c7a41201f8cd24/gistfile1.txt Joe On Fri, Mar 8, 2013 at 4:17 PM, Joe Van Dyk j...@tanga.com wrote:

[GENERAL] Joining against a view that uses an aggregate - performance issue

2013-03-08 Thread Joe Van Dyk
https://gist.github.com/joevandyk/070e4728c4c9fe1bf086/raw/8b1ecf4b2d4fd127a22cb19abe948c29d78c2158/gistfile1.txtsummarizes the problem. andres on #postgresql says that making #2 use a faster plan shouldn't be hard, but he doesn't seem #3 happening. I was surprised about #2 not being faster,

Re: [GENERAL] Joining against a view that uses an aggregate - performance issue

2013-03-08 Thread Joe Van Dyk
Oops, fixing link. https://gist.github.com/joevandyk/070e4728c4c9fe1bf086/raw/8b1ecf4b2d4fd127a22cb19abe948c29d78c2158/gistfile1.txt summarizes the problem. On Fri, Mar 8, 2013 at 4:17 PM, Joe Van Dyk j...@tanga.com wrote: