6 ms·
I agree - the disparity between the cost of idle connections in Postgres vs MSSQL is hampering our ability to migrate.
by btbuilder 5y ago
I agree - the disparity between the cost of idle connections in Postgres vs MSSQL is hampering our ability to migrate.
- pgaddict 5y agoCan you elaborate / quantify the memory requirements a bit? I don't have much experience with MSQQL in this respect, so I'm curious how big the difference is.
- btbuilder 5y agoSure, SQL Server supports a maximum of 32767 connections each of which use around 128kB. Meaning that if you use the max connections you’ll need 4GB for the connection overhead. We see no noticeable drop in performance with increased idle connection with our workload.
- gher-shyu3i 5y agoWhy are you migrating out of curiosity? Price reasons?
- btbuilder 5y agoYes, we have multiple RDS instances and wish to reduce costs.