Re: [PERFORM] Postgres 9 slave lagging

2011-04-11 Thread Merlin Moncure
On Mon, Apr 11, 2011 at 9:10 AM, Saurabh Agrawal wrote: > 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

[PERFORM] Postgres 9 slave lagging

2011-04-11 Thread Saurabh Agrawal
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