Re: BUG #17914: walsenders taking up all memory

Hi,

On Tue, May 2, 2023 at 5:56 AM PG Bug reporting form
<noreply(at)postgresql(dot)org> wrote:
>
> The following bug has been logged on the website:
>
> Bug reference: 17914
> Logged by: Stan S
> Email address: stashukny(at)gmail(dot)com
> PostgreSQL version: 14.3
> Operating system: AWS RDS - (Red Hat 7.3.1-12), 64-bit
> Description:
>
> Seeing the same issue as reported here:
> /message-id/CAMnUB3oYugXCBLSkih%2BqNsWQPciEwos6g_AMbnz_peNoxfHwyw%40mail.gmail.com
>
> In our case, logical_decoding_work_mem is set to 64 MB, yet walsenders can
> each take up 30 GB of memory, crashing our database.

Thank you for reporting this issue. I have two questions:

* Did you use streaming = off/on on the subscriber?
* How did you confirm the walsender used 30GB of memory?

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com