Hello Robert,
On 29 Jul 2003 at 10:10, Robert Millar wrote:
> I am a designer/developer and my hosting supplier now offers PostgreSQL along with the better known MySQL. I have
alsoworked with MS SQL server7. I cannot find any comparison on your site to tell me the benefits of PostgreSQL over
theseother two. Can you give me a summary of the biggest advantages of PostgreSQL over the others, and why I would want
toswitch?
When compared against mysql, postgresql offers several advanced features, that
include
* Transactions
* MVCC transaction paradigm for higher concurrent scalability
* Stored procedures
* Views
* Referential integrity
* Rules
* Multiple language bindings
* Inheritance
* SQL compliant implementation
etc.
For an application developer, these feature are very necessary to develop
application that guarantee integrity of data and mark clear isolation of
business and presentation logic.
I know mysql offers transactions but I do not think they are available in
default installation of mysql.
I am aware that mysql is rated faster than postgresql. But those who use
postgresql in production disagree. A properly tuned postgresql installation
should be fast enough by any measure. However the default postgresql
configuration is extremely conservative and is not at all set for a high
performance installation.
Compared to MS-SQL7, people see a performance advantage with postgresql but I
have no data to back this up as of now. Some of the advantages I mentioned
above such as multiple language bindings and rules stand true with MS-SQL as
well.
Please refer to http://techdocs.postgresql.org for documentation and other
materials.
Feel free to send us any question. I recommend to join pgsql-general list to
discuss any problems you might face.
HTH
Bye
Shridhar
--
Nachman's Rule: When it comes to foreign food, the less authentic the better. -
- Gerald Nachman
