Document application best practices for avoiding serialization errors

[raddevon]

[ahirner]

Any pointers so far? We run into many "could not serialize access due to read/write dependencies among transactions" errors where reads should be independent from inserts, at least from manually reasoning on them.