Search Postgresql Archives

Re: More grist for the PostgreSQL vs MySQL mill

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What I think bothers me is this whole concept that if PostgreSQL is to
flourish, MySQL has to be beaten down.  Folks, both products are free,
both can be used in the same shop (maybe not on the same computer if
your running them in production).  Putting down MySQL will not make
PostgreSQL any better, or vice versa.

Tom Lane wrote:
> "Michael Nolan" <htfoot@xxxxxxxxx> writes:
>> select count(*) from memmast where memid in (select plr_rated_memid from
>> tnmt_plr where plr_eventid in ('200607163681');
> 
>> This query takes about a second on PostgreSQL but takes OVER SEVEN MINUTES
>> on MySQL!
> 
> Yeah, and we probably would have sucked about as badly before 7.4 or so.
> There's a long way from "having subselects" to being able to optimize
> them decently.  AFAIK mysql is still at the "we've got subselects!"
> stage ...
> 
> 			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux