4 ms·
Transactions and Concurrency in PostgreSQL
- revskill 3y ago[flagged]
- ulrikrasmussen 3y agoThis is not a very good analogy I think. Serializable reads like a table or database level lock, but that is not at all what it is.
- ivanleoncz 3y agoWould you mind to explain your point, please? I'd be glad to learn more about it, for so far, I cannot agree with your comment, based on hands-on testing and documentations. Thanks.
- vore 3y ago"Security"? This has nothing to do with security. Also, it's not great to pollute technical forums with more ChatGPT-generated content when it would be more useful for domain experts to contribute their own knowledge.
- abdusco 3y agoI personally find it refreshing to read an example that is not "A deposits $10, B withdraws $10".
- heavenlyblue 3y agoThat's becuse this example explains pretty much none of the phenomena that is a result of the isolation levels.
- ivanleoncz 3y agoI'm sorry, but you're wrong... In Postgresql, the default ISOLATION LEVEL is "READ COMMITTED", which by standard, allows "NON-REPEATABLE READ" phenomena. When Transaction on the LEFT is COMMITTED (adding 100 to balance), the Transaction on the RIGHT will add 400 to a balance of 1100, and not to a balance of 1000 (reading NON-REPEATED value). You can do better than leaving this kind of comment that does not contribute in anything. Have good weekend.
- ivanleoncz 3y agoMe too, thanks. Would be nice if you can share some articles that you wrote regarding the matter, so I can have more inspiration. Looking forward to read them and learn from different examples and not the same "boiler plate" example that you can find on any DBMS documentation.
- ivanleoncz 3y agoI don't get your comment, to be quite honest. Besides, I don't like 3rd party A.I. services: the content that you see, is the content that I wrote. And this comment of yours seems more of something to offend than to contribute. I feel bad for you.
- edgyquant 3y agoBecause people wanting answers can go ask ChatGPT themselves. It helps no one to post its answers here and is a cheap way of trying to karma whore. That aside, it’s blatantly against the rules here. Go somewhere else if you want botspam
- ivanleoncz 3y agoKarma Whore? That's how you speak with people trying to share contents here? Does that does in favor of the rules then? Buddy, I feel bad for you. I hope you may have someone to love you on this Sunday, for you really need it. Don't be like that. Have a good day.
- ivanleoncz 3y agoYou're not contributing with the quality of this space, by sharing such comment, and using the "whore" word here.
- kjeetgill 3y agoVore's comment was critical of revskill's comment that was just ChatGPT output — not your article. Maybe you can't see dead comments?
- vore 3y agoIt seems you can’t see the comment I’m replying to because it’s been flagged and hidden if your settings are set that way – I am not talking about your article, I have no problem with it!
- karmakaze 3y agoThere's no mention of the REPEATABLE READ isolation level, though it mentions that READ COMMITTED can exhibit non-repeatable read behaviour. Here's the docs: [0] https://www.postgresql.org/docs/current/transaction-iso.html https://www.postgresql.org/docs/current/transaction-iso.html
- peheje 3y agoI do believe that a developer's grasp of database concepts, like handling concurrency issues and understanding isolation levels, even if not by specific terminology, can be an indicator of their depth in problem-solving, attention to detail, and experience with complex systems.