Re: Hot Standby remaining issues - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Hot Standby remaining issues
Date
Msg-id 1259751614.13774.21183.camel@ebony
Whole thread Raw
In response to Re: Hot Standby remaining issues  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Responses Re: Hot Standby remaining issues
List pgsql-hackers
On Wed, 2009-12-02 at 12:49 +0200, Heikki Linnakangas wrote:

> If a read-only transaction holds a lot of locks, consuming so much
> lock space that there's none left for the startup process to hold the
> lock it wants, it will abort and bring down postmaster. The patch
> attempts to kill any conflicting lockers, but those are handled fine
> already (if there's any conflicting locks, LockAcquire will return
> LOCKACQUIRE_NOT_AVAIL anyway). The problem is with non-conflicting
> locks using up the lock space.

Oh dear, another "nuke 'em all from orbit" scenario. Will do.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Hot Standby remaining issues
Next
From: Laurent Laborde
Date:
Subject: Re: Cost of sort/order by not estimated by the query planner