Postgres FM cover image

Memory

Postgres FM

CHAPTER

How to Optimize Shared Buffers

Check what your current workman setting is and if it's four meg bytes i'd check start checking your temporary yeah probably your cloud provider already tuned share buffers not too optimal state but good enough state. Quertuning and partitioning is also important here because it gives data locality. If you apply partitioning these things might start improving because instead of mixing all the new data in single table and indexes also it will start improving a lot, he says.

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