amr performance woes and a bright side [UPDATE]

ray at redshift.com ray at redshift.com
Wed Mar 23 14:27:54 PST 2005


| We are using PostgreSQL for its stored procedures, stability,
| SQL-compliance, and ability to handle 100G+ tables without flinching. It
| has been only recently that mysql has even added subqueries much less
| the higher functionality that we are seeking from a database; after
| evaluation, PostgreSQL was the enterprise-grade solution that we were
| seeking, and, with proper tweaking, does perform quite well. After one
| too many experiences with corrupt mysql tables, workarounds to
| implementing basic SQL compliant queries, and seeming lack of
| functionality, the switch to PostgreSQL was almost a no-brainer.
 
| Not trying to get into a db shootout as each system has its merits and
| drawbacks; for what we needed, PostgreSQL provided the solution.

Always good to hear from different perspectives :-)
 
| I am running a modified kernel that adds plenty of memory for use by the
| shared memory system PostgreSQL enjoys. 

10/4

Ray



More information about the freebsd-amd64 mailing list