MySQL might have a problem with Niagara, but it doesn't seem like it has the severe concurrency vulnerability you speak of.
There are many reasons to pick PostgreSQL, but this one doesn't seem to be a general thing. In general, MySQL seems to have problems with some kinds of threading, since their perfomance on Mac OS X is crappy as well for that reason.
-- Kind regards, Mikkel Høgh <mikkel@xxxxxxxxx> On 13/10/2008, at 10.43, Greg Smith wrote:
On Sun, 12 Oct 2008, Scott Marlowe wrote:It may well be that in a more realistic testing that mysql keeps up through 5 or 10 client connections then collapses at 40 or 50, while pgsql keeps climbing in performance.One of the best pro-PostgreSQL comparisons showing this behavior is at http://tweakers.net/reviews/649/7 MySQL owns that benchmark until you hit 40 users, then...ouch.--* Greg Smith gsmith@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
Attachment:
smime.p7s
Description: S/MIME cryptographic signature