Date: Sun, 13 Oct 2019 18:27:35 -0700 (MST)
From: dangal <danielito.gallo@gmail.com>
To: pgsql-performance@postgresql.org
Message-ID: <1571016455698-0.post@n3.nabble.com>
Subject: pg_stat_bgwriter
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Precedence: bulk

Dear I would like to share with you to see what you think about the
statistics of pg_stat_bgwriter

postgres =3D # select * from pg_stat_bgwriter;
=C2=A0checkpoints_timed | checkpoints_req | checkpoint_write_time |
checkpoint_sync_time | buffers_checkpoint | buffers_clean | maxwritten_clea=
n
| buffers_backend | buffers_
backend_fsync | buffers_alloc | stats_reset
------------------- + ----------------- + ------------ ----------- +
---------------------- + --------------- ----- + --------------- +
------------------ + --------- -------- + ---------
-------------- + --------------- + ------------------- ------------
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0338 | 6 | 247061792 | 89418 | 2939561 | 19872289 | 54876 |
6015787 |
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A00 |=
 710682240 | 2019-10-06 19: 25: 30.688186-03
(1 row)

postgres =3D # show bgwriter_delay;
=C2=A0bgwriter_delay
----------------
=C2=A0200ms
(1 row)

postgres =3D # show bgwriter_lru_maxpages;
=C2=A0bgwriter_lru_maxpages
-----------------------
=C2=A0100
(1 row)

postgres =3D # show bgwriter_lru_multiplier;
=C2=A0bgwriter_lru_multiplier
-------------------------
=C2=A02
(1 row)


Do you think it should increase bgwriter_lru_maxpages due to the value of
maxwritten_clean?
Do you think it should increase bgwriter_lru_maxpages,
bgwriter_lru_multiplier, and decrease bgwriter_delay due to the value of
buffers_backend compared to buffers_alloc?
Do you think a modification is necessary?
What values =E2=80=8B=E2=80=8Bwould you recommend?
thank you


--
Sent from: https://www.postgresql-archive.org/PostgreSQL-performance-f20500=
81.html