Joseph Schorr
Joseph Schorr
Updated
Rebased
Updated > Overall comment: I think there is the opportunity to use your new appendableHasher interface to only compute hashes that we're going to actually use. For example, we don't...
@john-conti Definitely doable. Most errors raised within SpiceDB are well-typed. For example: https://github.com/authzed/spicedb/blob/main/internal/dispatch/graph/errors.go. There are some that are not, but it would be fairly straightforward to add the remainder. Then...
@sjaakiejj Were the zedtokens stored *per user* or on the resource(s) being checked? Can you give some insight into the kinds of checks that were slowing down?
@sjaakiejj Do you have GC turned on in your Postgres datastore and, if so, how many transactions are in your transactions table? Also: what version of SpiceDB are you running?
@sjaakiejj Are all of those transactions within your configured GC window? That seems like a lot of transactions, unless you're writing that many relationships often
@sjaakiejj GC should be turned on by default, and the default window is 24 hours. That means, if GC is working, that your transactions table should only have those from...
@sjaakiejj Just checking in on this one; before we continue our investigation, can you confirm that GC is active and that those ~13M transactions are within the 24 hour period?
@sjaakiejj The health check in v1.12 or later should fail to return healthy if the database had not fully migrated to the correct revision.