Re: max_standby_delay considered harmful - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: max_standby_delay considered harmful
Date
Msg-id 1273431842.3936.1098.camel@ebony
Whole thread Raw
In response to Re: max_standby_delay considered harmful  (Florian Pflug <fgp@phlo.org>)
Responses Re: max_standby_delay considered harmful
List pgsql-hackers
On Sun, 2010-05-09 at 16:10 +0200, Florian Pflug wrote:

> Adding pause/resume seems to introduce some non-trivial locking
> problems, though. How would you handle a pause request if the recovery
> process currently held a lock?

(We are only talking about AccessExclusiveLocks here. No LWlocks are
held across WAL records during replay)

Just pause. There are no technical problem there.

Perhaps a danger of unforeseen consequences, though doing that might
also be desirable, who can say?

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: max_standby_delay considered harmful
Next
From: Dimitri Fontaine
Date:
Subject: Re: max_standby_delay considered harmful