Hi guys,
I'm a bit confused about PG cache.
I have a PostgreSQL 9.2 cluster (yes, we're planning on upgrading it to 12) with a master and a slave database.
The application is sending all read requests to the slave, where the master processes the writes.
A while ago we had to restart the master database server, and the application was slow for a couple of days while PG cache was warmed up.
Yesterday, we had to restart the slave database server and we did not have the same problem.
I would like to understand why?
Thanks!