is it possible to make this faster?

Поиск
Список
Период
Сортировка
Искать
От
Merlin Moncure
Тема
is it possible to make this faster?
Дата
в 17:07:26
Msg-id
b42b73150605251307id0e7998td4a3693f0d456f88@mail.gmail.com
Список
Дерево обсуждения
is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? Scott Marlowe <smarlowe@g2switchworks.com>
Re: is it possible to make this faster? Mark Lewis <mark.lewis@mir3.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? Jim Nasby <jnasby@pervasive.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? Mark Kirkwood <markir@paradise.net.nz>
Re: is it possible to make this faster? Bruno Wolff III <bruno@wolff.to>
Re: is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? Alan Hodgson <ahodgson@simkin.ca>
Re: is it possible to make this faster? Bruno Wolff III <bruno@wolff.to>
Re: is it possible to make this faster? "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Re: is it possible to make this faster? Jeff - <threshar@torgo.978.org>
Re: is it possible to make this faster? Tom Lane <tgl@sss.pgh.pa.us>
Re: is it possible to make this faster? "Merlin Moncure" <mmoncure@gmail.com>
Re: is it possible to make this faster? "Steinar H. Gunderson" <sgunderson@bigfoot.com>
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?

Merlin
В списке pgsql-performance по дате отправления
От: Dawid Kuroczko
Дата:
От: Bruno Wolff III
Дата:
FAQ