If you found this video helpful, you could check the full course on Udemy. In this course, you’ll find tips for tuning PostgreSQL 12 like a pro.
Use the link below to get a 60% OFF.
PostgreSQL High-Performance Tuning Guide - Full Course
https://www.udemy.com/course/postgres...
When there are thousands of users trying to read or write data to many different tables, reading from the files will result in a poor, non-scalable system. The reads and writes will result in searching for many files, opening these files, looking for specific data records, locking, editing, and unlocking. To make this a lot more scalable and faster, the concept of shared buffers is introduced.