Saurabh Agrawal wrote:
> max_standby_archive_delay = -1
>
> I noticed that whenever long running query executes on slave,
> slave starts lagging by master and as soon as query completes log
> files get applied immediately. Please help how can I avoid slave
> lag.
You can adjust max_standby_ar
Hi All,
I have setup postgres 9 master slave streaming replication but
experiencing slave lagging sometimes by 50 min to 60 min. I am not
getting exact reason for slave lag delay. Below are the details:
1. Master table contains partition tables with frequent updates.
2. Slave is used for report g
