Date: Thu, 25 May 2006 22:36:30 +0200
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: is it possible to make this faster?
Message-ID: <20060525203630.GA19881@uio.no>
Mail-Followup-To: pgsql-performance@postgresql.org
References: <b42b73150605251307id0e7998td4a3693f0d456f88@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: <b42b73150605251307id0e7998td4a3693f0d456f88@mail.gmail.com>
User-Agent: Mutt/1.5.11+cvs20060403

On Thu, May 25, 2006 at 04:07:19PM -0400, Merlin Moncure wrote:
> been doing a lot of pgsql/mysql performance testing lately, and there
> is one query that mysql does much better than pgsql...and I see it a
> lot in normal development:
> 
> select a,b,max(c) from t group by a,b;
> 
> t has an index on a,b,c.

The planner _should_ TTBOMK be able to do it by itself in 8.1, but have you
tried something along the following lines?

  select a,b,(select c from t t2 order by c desc where t1.a=t2.a and t1.b=t2.b)
  from t t1 group by a,b;

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