Memory
Postgres FM
How to Optimize Memory Consumption in Postgres 14
It's hard to understand in Linux how much memory is really consumed by each process but also we cannot limit it reliably. If we say workman 100 megabytes steel backend is allowed to use multiple times because of this behavior workman defines the limit for each operation not for backend and also we have parallel workers so together this becomes quite tricky topic. We first start from some safe workman setting safe approach is like okay we have max connections say 300 or 500 for our 96 or 244 core server big big one. Then we say okay we can give up to one gigabyte to a old backend right okay that's good so let's have some multiplier two or three because we know some queries can have
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
