>> I love PG, I've been using it since version 6x, and it has gotten >> fantastic over the years, and in many cases, I would choose it over >> Oracle, but for systems that need frequent updates, I have a lot of >> concerns. > > ...that's the price you pay for concurrency man...
I think that's a cop-out. Other databases can handle this case fine and they have MVCC. Are we not "open source" "free software" proponents? Isn't one of our motivations that we can do it better? This *is* a problem with PostgreSQL, and it *is* a concern for a reasonable number of potential deployments. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster