# Any database performance test for rails?

**URL:** <https://www.ruby-forum.com/t/any-database-performance-test-for-rails/116368>\
**Category:** Rails\
**Created:** [October 4, 2007, 10:29pm UTC](https://www.ruby-forum.com/t/any-database-performance-test-for-rails/116368 "2007-10-04T22:29:07Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![maul](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de0a6/32.png) [@maul](https://www.ruby-forum.com/u/maul)\
**Post date:** [October 4, 2007, 10:29pm UTC](https://www.ruby-forum.com/t/any-database-performance-test-for-rails/116368/1 "2007-10-04T22:29:07Z")

</div>

hey guys,

Our company use Asterisk and MS SQL for an IVR application. Our  
application is based heavly on MS SQL. But we want to change to a  
linux server with Asterisk+RAGI (rails AGI)and a database but I dont  
know whether mySQL or postgreSQL is better for performance for rails?

Are there any tests done to compate rails+mysql and rails+postgresql ?

Thanks

---

<div class="post-metadata">

**Author:** ![maul](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de0a6/32.png) [@maul](https://www.ruby-forum.com/u/maul)\
**Post date:** [October 4, 2007, 11:29pm UTC](https://www.ruby-forum.com/t/any-database-performance-test-for-rails/116368/2 "2007-10-04T23:29:58Z")

</div>

maul wrote:

> Are there any tests done to compate rails+mysql and rails+postgresql ?

Performance is more determined by what you are doing. The difference is  
speed is probably negligible compared to doing optimizations in your own  
app as both are used in high-availability/high-performance sites. Use  
what makes sense for you development environment. Either will  
performance nicely.

Eric

---

<div class="post-metadata">

**Author:** ![maul](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de0a6/32.png) [@maul](https://www.ruby-forum.com/u/maul)\
**Post date:** [October 5, 2007, 4:16am UTC](https://www.ruby-forum.com/t/any-database-performance-test-for-rails/116368/3 "2007-10-05T04:16:27Z")

</div>

On Oct 4, 1:28 pm, maul [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> hey guys,
> 
> Our company use Asterisk and MS SQL for an IVR application. Our  
> application is based heavly on MS SQL. But we want to change to a  
> linux server with Asterisk+RAGI (rails AGI)and a database but I dont  
> know whether mySQL or postgreSQL is better for performance for rails?
> 
> Are there any tests done to compate rails+mysql and rails+postgresql ?
> 
> Thanks

Yes, there are quite a few, not too hard to search for. you didn’t  
say anything about requirements, if you’re running exclusively in AR,  
or doing a little connection.execute(), or using smarter DBMS, PSQL,  
triggers, procedures, etc.

[http://groups.google.com/group/rubyonrails-talk/browse\_frm/thread/afb9c86050bb23e6/](http://groups.google.com/group/rubyonrails-talk/browse_frm/thread/afb9c86050bb23e6/)

> **[Database test: dual Intel Xeon 5160](https://tweakers.net/reviews/657/6/)**

---

<div class="post-metadata">

**Author:** ![maul](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/9de0a6/32.png) [@maul](https://www.ruby-forum.com/u/maul)\
**Post date:** [October 5, 2007, 6:45pm UTC](https://www.ruby-forum.com/t/any-database-performance-test-for-rails/116368/4 "2007-10-05T18:45:14Z")

</div>

maul wrote:  
[…]

> I dont  
> know whether mySQL or postgreSQL is better for performance for rails?
> 
> Are there any tests done to compate rails+mysql and rails+postgresql ?

Take a look at features, too. If you’re trying to store geographic data  
or use any stored procedures beyond the most rudimentary, PostgreSQL is  
definitely the way to go.

## Best,

Marnen Laibow-Koser  
removed\_email\_address@domain.invalid