Re: Planner having way wrong estimate for group aggregate

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Planner having way wrong estimate for group aggregate
Date: 2004-09-18 20:03:36
Message-ID: 20040918200336.GA4598@uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick Clery 2004-09-19 03:26:13 Re: Comparing user attributes with bitwise operators
Previous Message Tom Lane 2004-09-18 19:48:13 Re: Planner having way wrong estimate for group aggregate