[ 
https://issues.apache.org/jira/browse/SENTRY-1486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15553532#comment-15553532
 ] 

Alexander Kolbasov commented on SENTRY-1486:
--------------------------------------------

[~sravya] It would be good to get micro-benchmark run with Oracle and Postgres. 
As for metrics, I am skeptical about this - to get reasonable comparison we 
need a very controlled perf setup so that we compare apples to apples and we 
don't have Sentry benchmark - at least none that I am aware of.

> Sentry should use repeatable-read consistency level
> ---------------------------------------------------
>
>                 Key: SENTRY-1486
>                 URL: https://issues.apache.org/jira/browse/SENTRY-1486
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>    Affects Versions: 1.7.0, sentry-ha-redesign
>            Reporter: Alexander Kolbasov
>            Assignee: Alexander Kolbasov
>         Attachments: SENTRY-1486.001.patch, SENTRY-1486.002.patch
>
>
> Currently Sentry uses the "read-committed" consistency level which is the 
> default for the Datanucleus JDO library. This causes potential problems since 
> the state visible to each transaction can actually see updates from another 
> transactions, so it is very difficult to reason about any code that reads 
> multiple pieces of data.
> Instead it should use repeatable read" consistency which guarantees that any 
> transaction only sees the state at the beginning of a transaction plus any 
> updates done within a transaction.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to