Re: [PERFORM] Planner having way wrong estimate for group aggregate

2004-09-18 Thread Steinar H. Gunderson
On Sat, Sep 18, 2004 at 03:48:13PM -0400, Tom Lane wrote: > 7.4 doesn't have any statistics on expression indexes. 8.0 will do what > you want though. (I just fixed an oversight that prevented it from > doing so...) OK, so I'll have to wait for 8.0.0beta3 or 8.0.0 (I tried 8.0.0beta2, it gave me

Re: [PERFORM] Planner having way wrong estimate for group aggregate

2004-09-18 Thread Tom Lane
"Steinar H. Gunderson" <[EMAIL PROTECTED]> writes: > Now, my first notion was creating a functional index to help the planner: > ... > However, this obviously didn't help the planner (this came as a surprise to > me, but probably won't come as a surprise to the more seasoned users here :-) 7.4 doe