Re: max_standby_delay considered harmful - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: max_standby_delay considered harmful
Date
Msg-id 1273142915.12659.178.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
Re: max_standby_delay considered harmful
List pgsql-hackers
On Thu, 2010-05-06 at 11:36 +0200, Florian Pflug wrote:

> If there was an additional SQL-callable function that returned the backends the recovery process is currently waiting
for,plus one that reported that last timestamp seen in the WAL, than all those different cancellation policies could be
implementedas daemons that monitor recovery and kill backends as needed, no?
 
> 
> That would allow people to experiment with different cancellation policies, and maybe shed some light on what the
usefulpolicies are in practice.
 

It would be easier to implement a conflict resolution plugin that is
called when a conflict occurs, allowing users to have a customisable
mechanism. Again, I have no objection to that proposal.

-- Simon Riggs           www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: Partitioning/inherited tables vs FKs
Next
From: Florian Pflug
Date:
Subject: Re: max_standby_delay considered harmful