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

From Andreas Kretschmer
Subject Re: replication primary writting infinite number of WAL files
Date
Msg-id 90f8b99c-a3b0-c50c-db91-cab6ea3386d0@a-kretschmer.de
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

Am 24.11.23 um 13:52 schrieb Les:
>
>
> Andreas Kretschmer <andreas@a-kretschmer.de> wrote (2023. nov. 24., P, 
> 13:22):
>
>
>
>     Am 24.11.23 um 12:39 schrieb Les:
>     >
>     > Hello,
>     >
>
>     please check the database log, a VACUUM can also lead to massive wal
>     generation. Can you find other related messages? by the way, the
>     picture
>     is hard to read, please post text instead of pictures.
>
>
> First I was also thinking about vacuum.  But removing a replication 
> slot should have no effect on vacuum on the primary (AFAIK). Please 
> correct me if I'm wrong.
>

yeah, depends. there are 2 processes:

* 1 process generating the wal's, maybe a VACUUM
* an inactive slot holding the wals

For instance, if a standby not reachable the wal's will accumulated 
within the slot, till the standby is reachable again.


Andreas

-- 
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com




pgsql-general by date:

Previous
From: Les
Date:
Subject: Re: replication primary writting infinite number of WAL files
Next
From: Zahir Lalani
Date:
Subject: RE: Odd Shortcut behaviour in PG14