Postgres FM cover image

Parallelism

Postgres FM

00:00

How to Properly Plan Your Memory Usage

Memory planning is super difficult topic. I think a lot of people don't even realize what happens if it goes wrong. You either be either server goes down or you are becoming very, very slow. For safety, you need to take workman and multiply, for example, by two or three. But in reality, it's never allocated as a whole. Usually it's like some part of it. So you need to understand your workload on production to make proper decisions. Many servers are like kind of over provisioned because they know that queries, most of the queries are relatively light. They don't reach even one workman for single security. so it's good to have max connections.

Transcript
Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner