this is the tracking issue for fixing those TOUCH semantics

Question

this is the tracking issue for fixing those TOUCH semantics https github com authzed spicedb issues 901

Francisco Correia · Answer

Yes I ve seen this issue but for the time being should I be using CREATE

Jake · Answer

TOUCH is idempotent so if you re looking for idempotency then I would just use TOUCH unless you have a demonstrated performance challenge

Francisco Correia · Answer

We do have a lot of performance metrics that we re trying to hit so I think in that case CREATE makes more sense right

Jake · Answer

what datastore backend are you using

Francisco Correia · Answer

Also is there more information about the GC

Francisco Correia · Answer

We re currently testing both Postgres and Cockroach

Francisco Correia · Answer

But mostly we ve been using Postgres we want to see if it s good enough in terms of performance and how it scales with data

Jake · Answer

for cockroach I don t think we need to do anything to fix idempotency performance

Jake · Answer

for postgres early indications are that touch is more performant than create after the improvement

Francisco Correia · Answer

Yeah this question is mostly about Postgres

Francisco Correia · Answer

Touch is more performant for writes But what about for check queries

Francisco Correia · Answer

I guess my main concern is about how the check query scales with data

Jake · Answer

there will be some follow on effect for checks as well because there are fewer overall relationship versions

Francisco Correia · Answer

Are there any documented tests for that which I can read I m more worried about the check query performance than the write tbh which is why I think it might make more sense to only use the CREATE not the TOUCH but it depends on the correlation between check latency and data in the DB

Jake · Answer

if you can use `CREATE` by all means go for it some use cases are really challenging to know ahead of time whether the relationship you re trying to create already exists and if you re using `CREATE` that would return an error if the relationship exists

Francisco Correia · Answer

Got it thanks for the info

Francisco Correia · Answer

One last question will the GC eventually clean up data after duplicate TOUCH operations so that the DB looks the same as it would if CREATE had been used

Jake · Answer

yes that s correct