s**n
发帖数: 178 | | c*****t
发帖数: 1879 | 2 me... depending on what you want to do.
【在 s**n 的大作中提到】
: How is it?
| s**n
发帖数: 178 | 3 What is postgreSQL good at? In general, what kinds of applications use
postgreSQL? It seems that postgreSQL is not as popular as MySQL.
【在 c*****t 的大作中提到】
: me... depending on what you want to do.
| c******r
发帖数: 512 | 4 Postgres is just a database, it does what a database does. :-)
Not as goog as Oracle/DB2/SqlServer, but you cannot beat the price.
Compared to MySQL, if you query is relatively simple, go with MySQL.
I believe MySQL code is somewhat more efficient. If you need to run
joins between serveral big tables, you may have to go with Postgres.
【在 s**n 的大作中提到】
: What is postgreSQL good at? In general, what kinds of applications use
: postgreSQL? It seems that postgreSQL is not as popular as MySQL.
| c*****t
发帖数: 1879 | 5 PostgreSQL has one "unique" feature that is not present in Oracle,
that is arbitrary length text / binary array (up to 1GB) with no
performance penalties. So, if one is going to use BLOB, which is
harder to use, PostgreSQL is a better choice. SqlLite also has
this feature, but it is only for embeded database. This feature
does have one drawback (which is also part of reason why PostgreSQL
is slower for some queries) is that it does not have primary clustering
and requires autovaccum. However
【在 c******r 的大作中提到】
: Postgres is just a database, it does what a database does. :-)
: Not as goog as Oracle/DB2/SqlServer, but you cannot beat the price.
: Compared to MySQL, if you query is relatively simple, go with MySQL.
: I believe MySQL code is somewhat more efficient. If you need to run
: joins between serveral big tables, you may have to go with Postgres.
|
|
