rails-style-guide icon indicating copy to clipboard operation
rails-style-guide copied to clipboard

Published 20 hours ago • verified publisher icon rubocop

Add "Nested Transactions" section

Open wata727 opened this issue 1 year ago • 2 comments

See also https://github.com/rubocop/rubocop-rails/pull/1236

wata727 avatar Feb 11 '24 07:02 wata727

I didn’t look close yet, but seems interested at a glance https://about.gitlab.com/blog/2021/09/29/why-we-spent-the-last-month-eliminating-postgresql-subtransactions/

pirj avatar Mar 12 '24 17:03 pirj

Thank you for sharing this article. This article seems to be referring to performance issues caused by nested transactions in PostgreSQL.

Please note that this PR is not about whether you should use nested transactions, but only that if you do, you should not use joinable: false. This is a fairly partial mention, so I'm honestly not sure if it should be added to the style guide.

wata727 avatar Mar 13 '24 16:03 wata727