Postgres Pro
Downloads
Home   >   mailing lists

Re: Planner having way wrong estimate for group aggregate - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: Planner having way wrong estimate for group aggregate
Date
Msg-id 20040918200336.GA4598@uio.no
Whole thread Raw
In response to Re: Planner having way wrong estimate for group aggregate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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 zero difference) -- fortunately, I can probably wait at the rate
everything else is progressing here. :-)

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Planner having way wrong estimate for group aggregate
Next
From: Patrick Clery
Date:
Subject: Re: Comparing user attributes with bitwise operators