On Sat, 2011-03-05 at 07:24 -0500, Robert Haas wrote:
> On Sat, Mar 5, 2011 at 6:04 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> > It is documented that the selection of standby from a set of similar
> > priorities is indeterminate. Users don't like it, they can change it.
>
> That doesn't seem like a good argument to *change* the synchronous
> standby once it's already set.
If the order is arbitrary, why does it matter if it changes?
The user has the power to specify a sequence, yet they have not done so.
They are told the results are indeterminate, which is accurate. I can
add the words "and may change as new standbys connect" if that helps.
-- Simon Riggs http://www.2ndQuadrant.com/books/PostgreSQL Development, 24x7 Support, Training and Services