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