Hello spicy people! I'm having an issue with 1.8.0...
# spicedb
w
Hello spicy people! I'm having an issue with 1.8.0 on Postgres: it seems that it made all transactions
SERIALIZABLE
(https://github.com/authzed/spicedb/pull/581/files#diff-cc7f4962fde0ca83da82d95e2d7e23f00084437867c3cbe61eb70b4509576496R288). It's very problematic for me: I direct all the
checkPermission
without a zedToken to a read replica (AWS Aurora), and read replicas do not support the
SERIALIZABLE
level (see last point in https://www.postgresql.org/docs/current/hot-standby.html#HOT-STANDBY-CAVEATS). This means that I can't use a read replica at all with 1.8.0, which means I lose a lot of reliability and horizontal scalability 😬 I suppose the goal was to avoid unrepeatable reads? Could we use the
REPEATABLE READ
isolation level?