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

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app