Home > mailing lists

PG 9.2 slave restarted - cache not impacted - Mailing list pgsql-general

From	Lucas Possamai
Subject	PG 9.2 slave restarted - cache not impacted
Date	October 23, 2020 01:23:20
Msg-id	CAE_gQfVFXEKG=JTLgohUdw6y60f_vof6oGB0CEUAcwY+Gc-UzA@mail.gmail.com Whole thread Raw
Responses	Re: PG 9.2 slave restarted - cache not impacted (Michael Paquier <michael@paquier.xyz>)
List	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!

From: Mark Johnson
Date: 22 October 2020, 23:21:10
Subject: Re: Hot backup in PostgreSQL

From: Michael Paquier
Date: 23 October 2020, 06:19:59
Subject: Re: PG 9.2 slave restarted - cache not impacted