Differences between version 31 and previous revision of PostgresVsMysql.
Other diffs: Previous Major Revision, Previous Author, or view the Annotated Edit History
| Newer page: | version 31 | Last edited on Wednesday, December 14, 2005 10:26:46 am | by PhilMurray | Revert |
| Older page: | version 30 | Last edited on Wednesday, December 14, 2005 10:25:54 am | by PhilMurray | Revert |
@@ -27,12 +27,8 @@
# Unless you use PostGIS which is a patch against PostgreSQL, but often lags behind the latest version
# __Beware!__ As a result of MVCC, PostgreSQL cannot optimize a simple SELECT count(*) FROM table query. It will always use a sequential scan, this becomes very slow even on a table with only a few hundred thousand rows. This type of query is very common in webapps, as a result you have to design your database and app around it. People often assume this type of query is free in terms of processing. In MySQL it is optimised away.
# There are several projects out there with implement heavy modifications to PostgreSQL to implement replication, some rely on adding triggers to your database
-
-[MySQL]'s big advantage is that it's stupidly simple. If you don't know much about [SQL], you can get in and use [MySQL] and some of the great tools it has (like phpMyAdmin) to do pretty much what you want. These days however there are plenty of easy to use admin tools for [PostgreSQL] including psql, pgAccess, pgAdmin, phpPgAdmin, Tora.
-
-[MySQL]'s big disadvantage is that it's stupidly simple. If you have learnt about [SQL], you find out that in [MySQL] it is very hard to do complicated things, and if you do try and do complicated things, it bogs down and goes very slow. People may scoff that features such as "views" and "subselects" are "syntactic sugar" but they seriously improve the maintainability of your database, and when combined with well thought out constraints you can trust your data to be correct.
~UniForum posted studies that concluded that [MySQL] is slightly faster per query, but [PostgreSQL] can handle more concurrent connections. If you have that kind of load you really want to be looking at having redundancy and/or a bigger/better DataBase ([Oracle]?), though.
