is it possible to make this faster?
| От | Merlin Moncure |
|---|---|
| Тема | is it possible to make this faster? |
| Дата | |
| Msg-id | b42b73150605251307id0e7998td4a3693f0d456f88@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: is it possible to make this faster?
Re: is it possible to make this faster? Re: is it possible to make this faster? |
| Список | 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? Merlin
В списке pgsql-performance по дате отправления: