|
Re: [PLUG] databases compare (fwd) [Mysql - Postgresql compared]
|
Vijay Kumar
|
Jun 15, 2003 17:45 PDT
|
On 30 May 2003 at 7:42, Payal Rathod wrote:
| | On Fri, May 30, 2003 at 11:33:04AM +0530, Shridhar Daithankar wrote:
| | First of all, mysql is not RDBMS. So forget about it. It is a tiny SQL frontend
to file system storage..
|
wow! first time I heard this (I am not database girl).
Can you tell this in simpler language. I always thought that mysql was pretty good.
|
Technical issues:
* No foreign keys
* no stored procecedures
* no triggers,
* no subselect (Whatever mysql claims as subselect is pretty weak,FYI),
* is mysql DDL transactable? Postgresql can do
begin;
drop table foo;
--oops
rollback;
I am not sure if mysql transactions does that.
* Postgresql is honset to resources. Start postgresql with 100MB memory
assigned to it, it will never use more than a single byte over 100MB. Stop
postgresql, 100MB is back to system. My experience with mysql is not so. Had to
reboot a box to reclaim the memory. God know what it does with memory.
* Postgresql has schema. They were added recently, yes, but they are there.
* Postgresql will gain tablespaces very soon. May be next year. Pretty vital
for real world huge dependable databases.
* user definable languages
* user defined data types
* user defined operators
* unicode/multibyte character set support ( Not sure what mysql has). more of a
point of discussion rather than pro/con issue.
Policy issues
* Table types. What the heck is that? According to Codds rule, physical storage
of data should not be visible/of any concern of users.
* Postgresql has better space management with splitting huge files in 1GB
chucks. Good luck storing a 30GB database in a single file. Try dropping a
index on that on mysql.
* grave tendency to get diverted from standard SQL syntax.
Just some points I could think of out of my head.
Mysql is faster than postgresql is a myth. Fact is mysql is faster than
postgresql with default settings. And features of postgresql does not cause it
to slow down. If you don't use it they don't hog any resources..
| | wowow!! so I can safely use postgres whereever there is an requirement for oracle, right?
|
Almost always. Keyword is *almost*
HTH
Bye
Shridhar
--
Time is fluid ... like a river with currents, eddies, backwash. -- Spock, "The
City on the Edge of Forever", stardate 3134.0
--__--__--
|
|
 |
|
