On Wed, 2009-05-27 at 13:34 -0500, Kevin Grittner wrote:
> For the record, it became clear that I did a bad job of communicating
> on this thread...
You did good work, IMHO. Not everything will reach consensus and that's
not your fault.
> first implement table level predicate
> locks, since that has to exist and would provide a complete, if
> somewhat clumsy, serializable solution; then move on to more
> fine-grained locks. It would probably be workable, and possibly
> optimal, to have just table and page locks; although it seems likely
> that index range locks and row locks would also be worth it,
> eventually.
Do we need table-level predicate locks at all? What would they give us?
Why not just go straight for fine-grained page-level locks?
-- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support