
Memory
Postgres FM
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.