PostgreSQL: Script to check the status of Shared Buffer (Use pg_buffercache)

In the previous post, I loaded table into the buffer cache of PostgreSQL (Using pg_prewarm). PostgreSQL: Load table into Buffer Cache, Increase the Speed of Accessing data In this post, I am sharing a script for checking the status of Shared buffer area of PostgreSQL. Using pg_buffercache, we can check this. I took the script … Continue reading PostgreSQL: Script to check the status of Shared Buffer (Use pg_buffercache)