Sridhar wrote: > Yes, they are worthy of praise :) use mysql if ur data is not tooooo > big, but then big is a relative word. for "regular" use mysql is more > than enough and is very easy to use. postgresql is more heavy-weight is > an ORDBMS and may be used only if mysql seems insufficient.
As someone who moved from MySQL to PG not so long ago I had the following reasons. 1. Transactions support. 2. Row locking. 3. Doing lock/update on tables having more than 100k records. 4. MySQL barfs at more than 30-40 simultaneous connections. 5. Stored procedures. What I am still missing in PG is the flexibility of ALTER TABLE on MySQL. Most if it can be done in a round about way in PG but it definitely is not as easy as it is in MySQL. Also PG really came up to par with version 7.1 and beyond. By the way all my opinions are based on default untuned installations through rpms. Mithun _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
