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