Thread: Inquiry From Form [pgsql]

Inquiry From Form [pgsql]

From
Robert Millar
Date:
I am a designer/developer and my hosting supplier now offers PostgreSQL along with the better known MySQL. I have also
workedwith MS SQL server7. I cannot find any comparison on your site to tell me the benefits of PostgreSQL over these
othertwo. Can you give me a summary of the biggest advantages of PostgreSQL over the others, and why I would want to
switch?

Re: Inquiry From Form [pgsql]

From
"Shridhar Daithankar"
Date:
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