shared buffers and startup process

Joao Junior <[email protected]> Tue, 14 Jan 2020 16:29:51 +0100
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CABnPa_iu8LB=g-Cau8BhvJ1M4rOKRxZK-qzKdzvoG=1=2rbZbQ@mail.gmail.com>
--000000000000ff5a66059c1b43c3
Content-Type: text/plain; charset="UTF-8"

Hi,
I have a master slave setup with streaming replication.
I have a lots of wal files that were moved from master but not applied yet
, a big delay in the replica.
The replica is not working on  hotstandby mode ,  no conflicts to delay
wals apply  on it.

I would like to know if  increasing the amount of shared-buffers could help
the startup process applying the wals. I would like to know if in
the process of reading the wals and applying them,  blocks that should be
written will be  brought to shared buffer or not?? If yes, having a bigger
shared buffer will keep as much as possible the amount of pages there and
increase the startup process's speed avoiding pages's replacement and going
to the OS cache and maybe to the disk .
Does it make sense?

Thanks in advanced.

Regards,
Joao

--000000000000ff5a66059c1b43c3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,=C2=A0<div>I have a master slave setup with streaming r=
eplication.</div><div>I have a lots of wal files that were moved from maste=
r but not applied yet , a big delay in the replica.</div><div>The replica i=
s not working on=C2=A0 hotstandby mode ,=C2=A0 no conflicts to delay=C2=A0 =
wals apply=C2=A0 on it.</div><div><br></div><div><div><div>I would like to =
know if=C2=A0 increasing the=C2=A0amount of shared-buffers could help the s=
tartup process applying the wals. I would like to know if in the=C2=A0proce=
ss of reading the wals and applying them,=C2=A0 blocks that should be writt=
en will be=C2=A0 brought to shared buffer or not?? If yes, having a bigger =
shared buffer will keep as much as possible the amount of pages there and i=
ncrease the startup process&#39;s speed avoiding pages&#39;s replacement an=
d going to the OS cache and maybe to the disk .</div><div>Does it make sens=
e?</div><div><br></div><div>Thanks in advanced.</div><div><br></div><div>Re=
gards,</div><div>Joao</div><div><br></div><div><br></div></div></div></div>

--000000000000ff5a66059c1b43c3--