Boston Linux & Unix (BLU) Home | Calendar | Mail Lists | List Archives | Desktop SIG | Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings
Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU

BLU Discuss list archive


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

Re: Re: Why is Postgres so much better than MySQL?



 > 
> On Tue, 2008-01-08 at 23:06 -0500, [hidden email] wrote: 
>> > On Jan 8, 2008 12:47 PM,  <[hidden email]> wrote: 
>> >> 
>> >> I was just looking around the web for some stats, but everything I 
>> have 
>> >> found shows the latest PostgreSQL (>8.2) beats the tar out of MySQL 
>> 5.1, 
>> >> especially on multi-core processors. 
>> > 8>< 
>> >> Generally speaking, you'll get better performance using PostgreSQL 
>> under 
>> >> heavy load on equivalent hardware. So, again, hardware isn't part of 
>> the 
>> >> discussion. 
>> > 
>> > It would be helpful if you could provide references for these claims. 
>> Beyond my own professional experience: 
>> http://tweakers.net/reviews/657/5/database-test-dual-intel-xeon-5160-pagina-5.html
>> http://blog.page2rss.com/2007/01/postgresql-vs-mysql-performance.html
>> http://spyced.blogspot.com/2006/12/benchmark-postgresql-beats-stuffing.html
> 
> I've looked at the 3 links, and none of them include the settings in 
> my.cnf. nor do they include whatever settings they used for Postgres. 


BLU is a member of BostonUserGroups
BLU is a member of BostonUserGroups
We also thank MIT for the use of their facilities.

Valid HTML 4.01! Valid CSS!



Boston Linux & Unix / webmaster@blu.org