MySQL Performance: LAMP => Performance compare PostgreSQL vs MySQL

Members

Help

Home

Home » Performance » LAMP » Performance compare PostgreSQL vs MySQL

Show: Today's Messages :: Show Polls :: Message Navigator

Performance compare PostgreSQL vs MySQL [message #742]

Sat, 17 February 2007 11:59

howachen
Messages: 7
Registered: February 2007

Junior Member

Not many info. on the Internet comparing their performance in real world usage, anyone with experience want to comment?

Report message to a moderator

Re: Performance compare PostgreSQL vs MySQL [message #744 is a reply to message #742 ]

Sat, 17 February 2007 13:53

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

There is no such thing as real world usage, there are thousands of applications in real world and all of them are different.

In general you can build efficient application with both database systems, it is the question of your experience, bias and particular requirements. For example PostgreSQL often handles complex queries better while MySQL has power of multiple storage engines.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Performance compare PostgreSQL vs MySQL [message #764 is a reply to message #742 ]

Wed, 21 February 2007 13:21

howachen
Messages: 7
Registered: February 2007

Junior Member

As a MySQL expert, what do you think abt the following comments:

from:

http://www.enterprisedb.com/solutions/gotmysql.do

MySQL users know firsthand that MySQL is most effective for read-only environments and the web/edge tier - but not for applications in demanding OLTP environments, requiring enterprise-class reliability, availability, and scalability.

Report message to a moderator

Re: Performance compare PostgreSQL vs MySQL [message #765 is a reply to message #764 ]

Wed, 21 February 2007 16:35

Peter
Messages: 405
Registered: August 2006

Senior Member
Super Guru

Well,

It is as usually a lot of marketing talk. In reality you should look into what is important for your particular application and make a choice based on this information.

Too often however people do not like to spend time investigating and simply base decisions on rumors which can be outdated such as "MySQL does not support transactions" or silly "MySQL does not work with tables more than 10.000 rows"

MySQL is not perfect as any other Database Solution but be careful reading marketing talk as it usually only highlights benefits of home made solutions and not speaking about drawbacks.

Peter Zaitsev, MySQL Performance Expert
MySQL Performance Blog - http://www.mysqlperformanceblog.com
MySQL Consulting http://www.mysqlperformanceblog.com/mysql-consulting/

Report message to a moderator

Re: Performance compare PostgreSQL vs MySQL [message #1254 is a reply to message #765 ]

Mon, 14 May 2007 20:03

puzzler
Messages: 1
Registered: May 2007
Location: Germany

Junior Member

Yeah, and what I really do not like is that "sales by fear", like the "users will hit a wall". Speaking of Wall, wasnt it Larry who said "there is more than one way to do it"?

I guess the same principles count here, too!

Also: you can create some really bad solutions with the right software. I know what I am talking about, when I look at some of my code Very Happy

Cheers,
Ralf

http://www.tradebit.com/ - Sell your files

Report message to a moderator

Previous Topic:	Harddisks considerations for better MySQL performance
Next Topic:	Ruby vs. PHP for Web 2.0 applications

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 3 19:51:19 EDT 2008

Total time taken to generate the page: 0.00627 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.