News for hackers. Stuff that matters.

A comment on An early look at Postgres 14: Performance and monitoring Improvements. Parent comment

Re:An early look at Postgres 14: Performance and monitoring ... by btbuilder on Saturday May 22, 2021 @04:11PM (#27249886)
I agree - the disparity between the cost of idle connections in Postgres vs MSSQL is hampering our ability to migrate.
[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by pgaddict on Saturday May 22, 2021 @06:59PM (#27250990)
Can 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.
[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by btbuilder on Sunday May 23, 2021 @04:37AM (#27253353)
Sure, 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.

[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by gher-shyu3i on Sunday May 23, 2021 @07:06AM (#27254130)
Why are you migrating out of curiosity? Price reasons?
[ Parent | on HN ]
Re:An early look at Postgres 14: Performance and monitoring ... by btbuilder on Sunday May 23, 2021 @12:27PM (#27256250)
Yes, we have multiple RDS instances and wish to reduce costs.
[ Parent | on HN ]