2 ms·
I'm trying to find evidence on what memory usage is for MySQL for 1k connections vs postgres with 1k connections. I am finding a lot of people saying postgres h
by brianwawok 10y ago
I'm trying to find evidence on what memory usage is for MySQL for 1k connections vs postgres with 1k connections. I am finding a lot of people saying postgres has heavier connections but for 1k connections what's the difference. 1MB of memory? 1GB?
- kasey_junk 10y agohttps://wiki.postgresql.org/wiki/Number_Of_Database_Connections https://wiki.postgresql.org/wiki/Number_Of_Database_Connecti... Its a little outdated but I've found it largely holds. That is, you'd want a mighty box for 1000 concurrent connections. That said, connection queuing works really well with postgres such that throughput is frequently better at lower connection counts than at higher ones. I have no experience with mysql that is less than 15 years out of date.