PG 9.2 slave restarted - cache not impacted

From: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: PG 9.2 slave restarted - cache not impacted
Date: 2020-10-22 22:23:20
Message-ID: CAE_gQfVFXEKG=JTLgohUdw6y60f_vof6oGB0CEUAcwY+Gc-UzA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2020-10-23 03:19:59 Re: PG 9.2 slave restarted - cache not impacted
Previous Message Mark Johnson 2020-10-22 20:21:10 Re: Hot backup in PostgreSQL