What i am say is what i have heard in the other mailing lists
Postgresql turns out to be good if
The database is big
has lot of integrety constraints ( primary key / foreign key ) which will
become difficult to implement in mysql
u need lots of inner selects ( selects within selects)
cocurrency issues
Mysql is best suited even for big databases with relatively simple integrity
constraints
In the end the whole issue ends up if u answer whether u want to manually
implement referential integrity and use lots of inner selects
Hope this helps
Bye
Anand
ps : I have a file comparing mysql with postgresql .. Do u want it
ps: I have a
[EMAIL PROTECTED] wrote:
> Subject: Postgre and mySQL comparison
> Date: Mon, 27 Sep 1999 09:13:21 +0530
> From: Rahul Kumar <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
>
> Anyone used both postgresql and mysql (not msql)?
> Would like to have a comparison between the 2.
> e.g. Which is more robust, can handle larger qty's of data (GB's), better
> performance on indexed and full-table scan searches, supports ANSI92 SQL ...
>
> Regards,
> RK
--------------------------------------------------------------------
For more information on Linux in India visit http://www.linux-india.org/
The Linux India mailing list does not accept postings in HTML format.
