On Tue, Nov 20, 2012 at 4:08 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: >> It strikes me as cavalier to be resetting >> trycounter while sitting under the #1 known contention point for read >> only workloads. > > The only use for the trycounter is to know when to ERROR out with "no > unpinned buffers available", so not resetting that seems entirely > wrong. > > I would contest "the #1 known contention point" claim. We know that > the freelist lock is a point of contention under certain conditions, > but we (or at least I) also know that it is the mere acquisition of > this lock, and not the work done while it is held, that is important. Well, I'm speculating (without evidence) if that is in fact might not be always true. It certainly is hard to demonstrate with synthetic testing though. I guess the first step would be to whip up a diagnostic patch to confirm malfeasance in suspicious cases. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
