From cloud user perspective the persistence layer can be seen as a “black box”, meaning Temporal can change it without affecting application performance and scalability.
So don’t think there is a direct answer,
this thread has some comparisons if it helps.
Will check if there is any internal performance analysis data thats possible to share.