Request a Demo
Home   >   mailing lists

Re: seeing lag in postgresql replication - Mailing list pgsql-performance

From Mariel Cherkassky
Subject Re: seeing lag in postgresql replication
Date
Msg-id CA+t6e1=J-+CQDnAW=2uS+QAF0DJjtNCu=sQW1KbsHtUt001z9A@mail.gmail.com
Whole thread Raw
In response to seeing lag in postgresql replication  (Rambabu V <ram.wissen@gmail.com>)
List pgsql-performance
Tree view
Hi,
What version of postgresql do you have ?
Do you use streaming replcation or a different tool like repmgr or pgpool or something else ?
What are all the configurations for you wals(the parameters depends on your version..) ?
Do you see any errors or warnings in the server log ?

Regards, Mariel.


2018-01-08 11:21 GMT+02:00 Rambabu V <ram.wissen@gmail.com>:
Hi Team,

We are using system with 60 GB RAM and 4 TB , and this is AWS EC2 instance.
we are seeing some times replication lag 6 to 10 seconds, as this is very critical data, we should not see the lag, please help us on this to become lag zero.

Regards,

Rambabu Vakada,

PostgreSQL DBA,

9849137684.

pgsql-performance by date:

Previous
From: Rambabu V
Date:
Subject: seeing lag in postgresql replication
Next
From: Rambabu V
Date:
Subject: Need Help on wal_compression