Check out the exhaustive perfomance/feature comparision of these and other
databases at http://www.postgresql.org.
> 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.
In fact, it might surprise you to know that PostgreSQL does *not* yet
implement foriegn keys and referential integrity via native SQL.
The nice thing about PostgreSQL is that it is extensible (since all
catalogs including system catalogs are available for manipultion within
your database). This implies that referential integrity can be implemented
via your *own* C code using triggers or whatever else you think is the
cool thing. In fact one such tutorial extension (spi/refint.c) is
distributed with the sources and is a good guide for programmers wanting
extra features.
--------------------------------------------------------------------
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.
