[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-hackers
Subject:    Re: speed up a logical replica setup
From:       Fabrízio_de_Royes_Mello <fabriziomello () gmail ! com>
Date:       2024-01-31 17:39:28
Message-ID: CAFcNs+qAMdzd_73gwo3UE_25h+E-sHiV2paxfDgz=xw2y7hogw () mail ! gmail ! com
[Download RAW message or body]

On Wed, Jan 31, 2024 at 12:38 PM Euler Taveira <euler@eulerto.com> wrote:
>
>
> Hmm. I didn't try it with the failover patch that was recently applied.
Did you
> have any special configuration on primary?
>

Nothing special, here the configurations I've changed after bootstrap:

port = '5432'
wal_level = 'logical'
max_wal_senders = '8'
max_replication_slots = '6'
hot_standby_feedback = 'on'
max_prepared_transactions = '10'
max_locks_per_transaction = '512'

Regards,

--
Fabrízio de Royes Mello

[Attachment #3 (text/html)]

<div dir="ltr"><br>On Wed, Jan 31, 2024 at 12:38 PM Euler Taveira &lt;<a \
href="mailto:euler@eulerto.com">euler@eulerto.com</a>&gt; \
wrote:<br>&gt;<br>&gt;<br>&gt; Hmm. I didn&#39;t try it with the failover patch that \
was recently applied. Did you<br>&gt; have any special configuration on \
primary?<br>&gt;<br><br>Nothing special, here the configurations I&#39;ve changed \
after bootstrap:<div><br></div><div>port = &#39;5432&#39;<br>wal_level = \
&#39;logical&#39;<br>max_wal_senders = &#39;8&#39;<br>max_replication_slots = \
&#39;6&#39;<br>hot_standby_feedback = &#39;on&#39;<br>max_prepared_transactions = \
&#39;10&#39;<br>max_locks_per_transaction = \
&#39;512&#39;<br><br>Regards,</div><div><br>--<br>Fabrízio de Royes \
Mello</div></div>



[prev in list] [next in list] [prev in thread] [next in thread]