Postgres FM cover image

Memory

Postgres FM

CHAPTER

How to Optimize Your Database for Maximum Performance

The default is so low that it's unlikely to be a good starting point and 25% probably gives you a better starting point for experimentation but then to experiment you need restarts. If your data doesn't fit in RAM which is like a lot of people it will  a lot of people if you're working on a small database your data might well fit in less than 25%. So the people that are going to have problems with this were those who don't use shared buffers.

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.
App store bannerPlay store banner