3min chapter

Postgres FM cover image

Parallelism

Postgres FM

CHAPTER

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.

00:00

Get the Snipd
podcast app

Unlock the knowledge in podcasts with the podcast player of the future.
App store bannerPlay store banner

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode

Save any
moment

Hear something you like? Tap your headphones to save it with AI-generated key takeaways

Share
& Export

Send highlights to Twitter, WhatsApp or export them to Notion, Readwise & more

AI-powered
podcast player

Listen to all your favourite podcasts with AI-powered features

Discover
highlights

Listen to the best highlights from the podcasts you love and dive into the full episode