Hi Ram,
29 set 2024, 12:29 Ramakrishna m :
*We are planning to set up logical replication from a standby to another
> server. When the primary goes down, there is no issue as the standby
> becomes the primary and the logical slots are already present. However,
> when the standby goes down, these
Hi Justin and Greg,
Thank you for your input and recommendations. We understand your point
regarding separating the tables into different publications and
subscriptions.
However, due to certain business constraints, we are unable to implement
this approach at the moment.
*We are planning to set u
On Sat, Sep 21, 2024 at 3:08 PM Ramakrishna m wrote:
> I would greatly appreciate any suggestions you may have to help avoid
> logical replication delays, whether through tuning database or operating
> system parameters, or any other recommendations
>
In addition to the things already answered:
Hi Ramakrishna,
I am not following the reasoning on not separating the tables into
different publications and subscriptions. I set up logical replication all
the time in many different environments, one of the audits I perform before
deploying LR is looking at pg_stat_all_tables and WAL creation
Hi Justin,
Thank you for your suggestions and detailed insights.
Due to certain business constraints, we are unable to split the tables into
parallel publications. All of the tables involved are primary key tables,
which adds further complexity to separating them into multiple publications.
That
Hi Ramakrishna,
4GB of WAL generated per minute is a lot. I would expect the replay on the
subscriber to lag behind because it is a single process. PostgreSQL 16 can
create parallel workers for large transactions, however if there is a flood
of small transactions touching many tables the single
Hi Team,
adding one more point here,
5. Pg_stat_replication_slot total_txn count reduces when lag occurs .Does
decoding stop in case of logical replication delay?
On Tue, 23 Apr 2024 at 22:55, Ramakrishna m wrote:
> Hi Team,
>
> I am facing replication lag in postgres16 at times,not able to
