search

EndPointCorp / end-point-blog

End Point Dev blog
https://www.endpointdev.com/blog/
17 stars 65 forks source link

Comments for PostgreSQL Serializable and Repeatable Read Switcheroo #501

Open phinjensen opened 6 years ago

phinjensen commented 6 years ago

Comments for https://www.endpointdev.com/blog/2011/09/postgresql-allows-for-different/ By Greg Sabino Mullane

To enter a comment:

  1. Log in to GitHub
  2. Leave a comment on this issue.
phinjensen commented 6 years ago 
original author: David Christensen
date: 2011-09-28T12:18:02-04:00

Greg,

Was this change made due to just being a backwards-compatible syntax fix that would work with all versions of PG that Bucardo works with, or is there some incompatibility with true SERIALIZABLE mode that you would need to avoid that in 9.1? For that matter, what is the difference between REPEATABLE READ/SERIALIZABLE as far as Bucardo is concerned?

David

phinjensen commented 6 years ago 
original author: Greg Sabino Mullane
date: 2011-09-28T12:22:00-04:00

The former: I've not had time yet to see exactly if there are cases where true serializability would benefit Bucardo. I suspect not, as the main reason we are using it is to to get a consistent snapshot, not to order transactions. Bucardo 4 had many seriazliable errors on busy systems, but that should be much less in Bucardo 5. It would be nice to know exactly how much of an overhead SSI is: the docs only say there is some...