Postgres Pro
Downloads
Home   >   mailing lists

Re: Summary and Plan for Hot Standby - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Summary and Plan for Hot Standby
Date
Msg-id 1260115009.13774.45369.camel@ebony
Whole thread Raw
In response to Re: Summary and Plan for Hot Standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Summary and Plan for Hot Standby  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
List pgsql-hackers
Tree view 
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.

--
 Simon Riggs           www.2ndQuadrant.com
Attachment

pgsql-hackers by date:

Previous
From: Jonas J
Date:
Subject: A sniffer for the buffer
Next
From: Tom Lane
Date:
Subject: Re: Allowing DML RULEs that produce Read Only actions during RO xacts