Re: Slow Query- Simple taking
| От | Robert Haas |
|---|---|
| Тема | Re: Slow Query- Simple taking |
| Дата | |
| Msg-id | AANLkTin8uiOvoELnO3bpQuTL1mQvi=zNHX-dSkRG8qMq@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Slow Query- Simple taking ("Ozer, Pam" <pozer@automotive.com>) |
| Ответы |
Re: Slow Query- Simple taking
|
| Список | pgsql-performance |
On Tue, Oct 19, 2010 at 6:05 PM, Ozer, Pam <pozer@automotive.com> wrote: > On mysql the same query only takes milliseconds not seconds. That's a > big difference. I can believe that MySQL is faster, because they probably don't need to do the bitmap heap scan. There is a much-anticipated feature called index-only scans that we don't have yet in PG, which would help cases like this a great deal. But I don't see how MySQL could send back 116,000 rows to the client in milliseconds, or sort them that quickly. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-performance по дате отправления: