On Tue, Oct 19, 2010 at 6:05 PM, Ozer, Pam <pozer(at)automotive(dot)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