Re: startup process stuck in recovery

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Christophe Pettus <xof(at)thebuild(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: startup process stuck in recovery
Date: 2017-10-10 15:05:32
Message-ID: 18691.1507647932@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Tom Lane wrote:
>> Hmm, I tried to reproduce this and could not. I experimented with
>> various permutations of this:

> This problem is probably related to commit 9b013dc238c, which AFAICS is
> only in pg10, not 9.5.

You're right, I was testing on HEAD, so that patch might've obscured
the problem. But the code looks like it could still be O(N^2) in
some cases. Will look again later.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2017-10-10 15:26:18 Re: Can master and slave on different PG versions?
Previous Message David G. Johnston 2017-10-10 14:52:10 Re: [asking about how to upgrade docker postgresql without losing the data]