Postgres Architecture | The Backend Engineering Show
The Backend Engineering Show with Hussein Nasser
00:00
PostgreSQL
In Gen X, for every connection, you get a process. That's why there's a property called max connections. And this is set to 100, which is a very low number if you think about it, right? Because they know that that's a bad idea. If you have a lot of connections, soon enough, your database will be run out of RAM and the CPU will just die because of context switching between all these processes. Linux doesn't do that pretty much any no operating system does that for optimization reasons.
Transcript
Play full episode
