A machine that operates continuously is a perfect machine, and no machine is perfect.
The greater the number and diversity of machines, as well as their geographical dispersion, the greater their availability.
In this respect, a mix of renewables (solar, wind, geothermal, biomass, etc.) deployed on a continental scale, along with storage (batteries and V2(G|H), hydro, green hydrogen...) is unbeatable (total cost, availability, risk, etc.).
Laziness leads us to conserve resources, and impatience to "save time" (which is a resource, but of a unique nature).
Pride also leads us to make our work more robust, so that it "always works well."
Thus, two fundamental principles are respected: optimization and robustness.
Is your problem related to various parts of the code being in distinct transactions? Can you try a version having all parts commiting then immediately synchronizing with each other, then SELECT'ing?
I found a fix to the problem, although I never quite pinned down why it was necessary. It wasn't a commit problem, but rather had to do with two objects pointing to the same third object as its "parent", whereas the third object only pointed to one of those other two objects as its "daughter". When queried from either object about the third object's daughter, it gave an answer pointing to that object, despite the parent pointing to just one of the two objects. The fix was to make the non-owned object point to a different owner. But I still am not clear why that was necessary.
IMHO the main difference between PostgreSQL and any 'competitor' is that in most cases a software developer will quickly find not only how to use it quite properly for his use case but also why some way he adopted isn't right and triggers some non-negligible problem.
There are many reasons for this: most software developers have more than a vague idea about its underlying concepts, most error messages are clear, the documentation is superb, there are many ways to tap into the vast knowledge of a huge and growing community...
Character is destiny. The content of your character is your choice. Day by day, what you choose, what you think and what you do is who you become. -- Heraclitus
