Re: Replaying 48 WAL files takes 80 minutes

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Replaying 48 WAL files takes 80 minutes
Date: 2012-10-29 14:29:01
Message-ID: 20121029142901.GE12961@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Albe Laurenz wrote:
> I am configuring streaming replication with hot standby
> with PostgreSQL 9.1.3 on RHEL 6 (kernel 2.6.32-220.el6.x86_64).
> PostgreSQL was compiled from source.
>
> It works fine, except that starting the standby took for ever:
> it took the system more than 80 minutes to replay 48 WAL files
> and connect to the primary.
>
> Can anybody think of an explanation why it takes that long?

Can you do a quick xlogdump of those files? Maybe there is something
unusual (say particular types of GIN/GiST index updates) on the files
that take longer.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Albe Laurenz 2012-10-29 15:04:00 Re: Replaying 48 WAL files takes 80 minutes
Previous Message Shaun Thomas 2012-10-29 13:25:15 Re: Prepared statements slow in 9.2 still (bad query plan)