Re: replication primary writting infinite number of WAL files - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: replication primary writting infinite number of WAL files
Date
Msg-id 20231126113019.y5wburrn7bykcocz@hjp.at
Whole thread Raw
In response to Re: replication primary writting infinite number of WAL files  (Les <nagylzs@gmail.com>)
Responses Re: replication primary writting infinite number of WAL files
List pgsql-general
On 2023-11-24 22:05:12 +0100, Les wrote:
>     And there is nothing in the logs in that time period besides "checkpoints
>     are happening too frequently"?
>
>
>
> Here are all the logs we have from that minute.
>
> ╰─# journalctl CONTAINER_ID=33d8b96b9062 --since '2023-11-24 10:18:00' --until
> '2023-11-24 10:21:00.000'                                  

[citing only the "checkpoints are occurring too frequently" entries:]
> nov 24 10:18:04 docker02 33d8b96b9062[1200]: 2023-11-24 10:18:04.517 CET [35] > LOG:  checkpoints are occurring too
frequently(22 seconds apart) 
> nov 24 10:18:26 docker02 33d8b96b9062[1200]: 2023-11-24 10:18:26.776 CET [35] > LOG:  checkpoints are occurring too
frequently(22 seconds apart) 
> nov 24 10:18:49 docker02 33d8b96b9062[1200]: 2023-11-24 10:18:49.002 CET [35] > LOG:  checkpoints are occurring too
frequently(22 seconds apart) 
> nov 24 10:19:11 docker02 33d8b96b9062[1200]: 2023-11-24 10:19:11.320 CET [35] > LOG:  checkpoints are occurring too
frequently(23 seconds apart) 
> nov 24 10:19:34 docker02 33d8b96b9062[1200]: 2023-11-24 10:19:34.058 CET [35] > LOG:  checkpoints are occurring too
frequently(23 seconds apart) 
> nov 24 10:19:56 docker02 33d8b96b9062[1200]: 2023-11-24 10:19:56.160 CET [35] > LOG:  checkpoints are occurring too
frequently(22 seconds apart) 
> nov 24 10:20:19 docker02 33d8b96b9062[1200]: 2023-11-24 10:20:19.691 CET [35] > LOG:  checkpoints are occurring too
frequently(23 seconds apart) 
> nov 24 10:20:42 docker02 33d8b96b9062[1200]: 2023-11-24 10:20:42.938 CET [35] > LOG:  checkpoints are occurring too
frequently(23 seconds apart) 

Interesting. If the database writes 1.5 GB/s of WALs and max_wal_size is
the default of 1GB, shouldn't there be a checkpoint about every 0.7
seconds instead of just every 22 seconds?

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Can user specification of a column value be required when querying a view ?
Next
From: "Peter J. Holzer"
Date:
Subject: Re: pg_getnameinfo_all() failed: Temporary failure in name resolution