| From: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de> |
|---|---|
| To: | Les <nagylzs(at)gmail(dot)com> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: replication primary writting infinite number of WAL files |
| Date: | 2023-11-24 12:58:29 |
| Message-ID: | 90f8b99c-a3b0-c50c-db91-cab6ea3386d0@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Am 24.11.23 um 13:52 schrieb Les:
>
>
> Andreas Kretschmer <andreas(at)a-kretschmer(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zahir Lalani | 2023-11-24 13:00:59 | RE: Odd Shortcut behaviour in PG14 |
| Previous Message | Les | 2023-11-24 12:52:23 | Re: replication primary writting infinite number of WAL files |