Re: Regarding huge logical slot lag between source and target

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Durgamahesh Manne <maheshpostgres9(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>, PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org>
Subject: Re: Regarding huge logical slot lag between source and target
Date: 2026-10-18 18:45:25
Message-ID: 03f09ff7d28decc50b84ec2b4d697b7a0d8f0dc3.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, 2026-10-18 at 23:16 +0530, Durgamahesh Manne wrote:
> Hi what is the formula to set this logical_decoding_work_mem?
>
> I set 4Gb 
> When we have huge DML ops what value can be recommended.
>
> Ram 128gb 

I don't think there is a formula, but 4GB is pretty high.

Can you be a bit more specific about the "huge DML operations"?

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Manu 2026-10-18 19:05:11 Re: Regarding huge logical slot lag between source and target
Previous Message Laurenz Albe 2026-10-18 18:43:46 Re: Regarding huge logical slot lag between source and target