Re: Hot Standby: Relation-specific deferred conflict resolution

On Fri, 2010-01-29 at 08:26 +0200, Heikki Linnakangas wrote:
> Simon Riggs wrote:
> > Conflict resolution improvements are important to include in this
> > release, as discussed many times. Proposal given here
> > http://archives.postgresql.org/pgsql-hackers/2009-12/msg01175.php
> > presents a viable design to improve this.
> >
> > Following patch is a complete working implementation of that design.
> > I'm still testing it, but its worth publishing as early as possible to
> > allow discussion. Not for commit, just yet, but soon.
>
> Um, you're not considering this for 9.0, are you? I think it's time to
> concentrate on the must-fix issues and fix the rough edges in what we have.

Yes, it is important.

> For example, the "can't start hot standby mode from a shutdown
> checkpoint" issue is a must-fix issue in my opinion, about 10x as
> important as this. When that was last discussed, many others agreed. I
> run into that all the time when testing streaming replication, and every
> time I go "Huh, why isn't the standby opening up for connections?", and
> then, "Ahh, it's this stupid shutdown checkpoint issue again".

That was not the feedback I have received. Nobody has commented on that
to me, though many have commented on the need for the current patch. As
mentioned, I went to the trouble of running a meeting to gain additional
feedback and the result was very clear.

Of course, if we ignore any feature, then someone will say "its that
stupid issue again", but that won't imply we got our priority wrong.

> And the VACUUM FULL issue is still hanging too.

Yes, that is a must fix.

--
Simon Riggs www.2ndQuadrant.com