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!