Bug 334 - Review transaction isolation levels
Summary: Review transaction isolation levels
Status: NEW
Alias: None
Product: Slony-I
Classification: Unclassified
Component: slon (show other bugs)
Version: devel
Hardware: All All
: low normal
Assignee: Slony Bugs List
URL:
Depends on:
Blocks:
 
Reported: 2014-03-13 08:09 UTC by Christopher Browne
Modified: 2014-03-13 08:09 UTC (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Christopher Browne 2014-03-13 08:09:58 UTC 
Where possible, we should consider using READ ONLY transactions.

Some cases of SERIALIZABLE likely ought to become REPEATABLE READ, if on a Postgres version that supports it.  (Actually, on the versions that do NOT have distinct interpretations, e.g. 9.0 and earlier, we can request REPEATABLE READ, and will get SERIALIZABLE instead.  Which is OK, as on the elder versions, SERIALIZABLE isn't as heavy-handed as it is in 9.1+.)