I am using Postgre with NodeJS. If I fire of 500 threads to test the scalability of the application it fails. I have heard Postgre has limitations when it comes to connection capacity. I don't have this problem with SQL Server or MongoDB. Each thread makes a call to Node, which then calls a simple Sql Statement to pull back the data. However, It works fine for 5 threads. Again, I need to know how to scale Postgre so it is a viable option.
