Skip site navigation (1) Skip section navigation (2)

is it possible to make this faster?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: is it possible to make this faster?
Date: 2006-05-25 20:07:19
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
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.

in my sample case with cardinality of 1000 for a, 2000 for b, and
300000 records in t, pgsql does a seq. scan on dev box in about a
second (returning 2000 records).

recent versions of mysql do much better, returning same set in < 20ms.
mysql explain says it uses an index to optimize the group by somehow.
is there a faster way to write this query?



pgsql-performance by date

Next:From: Bruno Wolff IIIDate: 2006-05-25 20:23:14
Subject: Re: is it possible to make this faster?
Previous:From: Dawid KuroczkoDate: 2006-05-25 17:07:11
Subject: Re: Optimizing a huge_table/tiny_table join

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group