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,
We have configured bidirectional replication (but traffic can only flow in
one direction) between two data centers (distance: 1000 km, maximum Network
latency: 100 ms) with an application TPS (transactions per second) of 700
at maximum.
We are fine with handling up to 500 TPS without obs
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
Hi Team,
I am facing replication lag in postgres16 at times,not able to find the
reason.
Please find the configuration:
1) Two replication slots for two servers (1 is the same data center,
another remote)
2) weekly once/twice facing lag(around 2GB for 1k TPS environment) in the
remote replicati
