Memory
Postgres FM
How to Set Effective Cache Size for Postgres
In general like if we decide start with 25% for buffer pool I would just put 75% for effective cache size as a starting point. Since it's not a location postgres will work and this helps us own lower environment where we don't have enough memory. The planar doesn't look at real available RAM real available CPU disk doesn't know about it anything and doesn't look to a shared buffer saving it just looks at effective cache size. We want planar be have similar to production actually exactly like production we use planar settings and work mem the same as on production.
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.
