williamdclt
03/16/2023, 10:23 AMERROR: could not serialize access due to read/write dependencies among transactions (SQLSTATE 40001)
.
I'd like to understand it a bit more: it sounds that it's because I'm parallelising the ingestion of data (multiple writers) and SpiceDB uses a serializable
isolation level? Is there a retry on SpiceDB side? Why does SpiceDB require serializable
?vroldanbet
03/16/2023, 10:37 AMwilliamdclt
03/16/2023, 10:38 AMJoey
03/16/2023, 10:39 AMvroldanbet
03/16/2023, 10:56 AMWriteRelationships
requests. It fixed an N+1 query. If your writes contain one single target relation, then it's the same performance. If your writes contain more than 1 target, it eliminates one query and rountrip. If your writes have N target relation, it goes from N queries, to 1