Postgres FM cover image

Memory

Postgres FM

CHAPTER

The Importance of Shared Buffers in Postgres

A shared buffer is more like physical setting which will affect timing of code execution. Page cache also needs tuning sometimes because if we accumulate a lot of dirty pages in page cache it's not directly related to posgas but it's related to overall performance of our database. CCTL adjusting kernel settings so page cache doesn't grow a lot and the personal system flashes dirty buffers with PTFlash often.

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