Horton

Re: Summary and Plan for Hot Standby

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Simon Riggs <simon@2ndQuadrant.com>
Cc: pgsql-hackers@postgresql.org
Date: 2009-12-06T18:35:39Z
Lists: pgsql-hackers 
Simon Riggs wrote:
> On Sun, 2009-11-15 at 16:07 +0200, Heikki Linnakangas wrote:
> 
>> - When switching from standby mode to normal operation, we momentarily
>> hold all AccessExclusiveLocks held by prepared xacts twice, needing
>> twice the lock space. You can run out of lock space at that point,
>> causing failover to fail.
> 
> Proposed patch to fix that attached.

Doesn't eliminate the problem completely, but certainly makes it much
less likely.

-- 
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com