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?