Memory
Postgres FM
00:00
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
Transcript
Play full episode
