Re: Inquiry From Form [pgsql]
От | Shridhar Daithankar |
---|---|
Тема | Re: Inquiry From Form [pgsql] |
Дата | |
Msg-id | 3F26D2C8.28550.5F50E7D@localhost обсуждение исходный текст |
Ответ на | Inquiry From Form [pgsql] (Robert Millar <rmillar@studioimpressions.com>) |
Список | pgsql-advocacy |
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
В списке pgsql-advocacy по дате отправления: