[issue] wal_buffers_full increases depending on the values of wal_buffers and wal-segsize

From: 와따가따 <lght2000(at)gmail(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: [issue] wal_buffers_full increases depending on the values of wal_buffers and wal-segsize
Date: 2022-04-25 07:51:43
Message-ID: CAAEzU5uPUWnp-d=ensVkvfSEnQNm6mFUPe-aLy=Pu1LwSb3CtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

If the wal segment size is larger than the wal_buffers parameter value, the
value of the wal_buffers_full column of pg_stat_wal increases after
database shutdown and startup.

pg_controldata | grep "Bytes per WAL segment"
Bytes per WAL segment: 1073741824

wal_buffers = 16MB

---- DB shutdown and restart
postgres=# select * from pg_stat_wal;
wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write |
wal_sync | wal_write_time | wal_sync_time | stats_reset
-------------+---------+-----------+------------------+-----------+----------+----------------+---------------+-------------------------------
6165 | 462 | 14071380 | * 126070* | 126115 |
40 | 0 | 0 | 2022-04-25
14:28:04.746772+09
(1 row)

If wal_buffers size and wal_segment size are the same, wal_buffers_full
column does not increase.

pg_controldata | grep "Bytes per WAL segment"
Bytes per WAL segment: 16777216

wal_buffers = 16MB

postgres=# select * from pg_stat_wal;
wal_records | wal_fpi | wal_bytes | wal_buffers_full | wal_write |
wal_sync | wal_write_time | wal_sync_time | stats_reset
-------------+---------+-----------+------------------+-----------+----------+----------------+---------------+-------------------------------
6161 | 461 | 14062929 | * 0 *| 39 |
36 | 0 | 0 | 2022-04-25
12:13:35.838092+09
(1 row)

Is this a bug?

The postgreSQL version currently in use is 14.2, and the database was
restarted without performing DML and DDL.

I wonder if it doesn't matter if the values of wal_buffers and wal-segsize
are different.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-04-25 13:36:12 Re: BUG #17467: Perf degradation after switching to latest jdbc drivers
Previous Message alias 2022-04-25 06:07:49 domain type with create cast not working on pg15, but work on pg14