Message-ID: <53AFCEE3.4080009@vmware.com>
Date: Sun, 29 Jun 2014 11:31:31 +0300
From: Heikki Linnakangas <hlinnakangas@vmware.com>
Organization: VMware
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Icedove/24.5.0
MIME-Version: 1.0
To: Soni M <diptatapa@gmail.com>, <pgsql-performance@postgresql.org>
Subject: Re: Postgres Replaying WAL slowly
References: 
 <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
In-Reply-To: 
 <CAAMgDXm5Y9QPELKvCGBrFvPcuR0ENVA1tEYRcazhDSxs6xnX5w@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

On 06/29/2014 11:14 AM, Soni M wrote:
> Everything works fine until on Thursday we have high load on master, and
> after that every streaming replica lag further behind the master. Even on
> night and weekend where all server load is low. But the slony slave is OK
> at all.

What does 'top' on the standby say? Is the startup process using 100% of 
(one) CPU replaying records, or is it waiting for I/O? How large is the 
database, does it fit in RAM? Any clues in the system or PostgreSQL logs?

- Heikki


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance