I’ll be honest as a 1 man operation, my flowchart is fairly simple:
-Can psql do this? Then make the statement to do it
-Gotta do it on code? Make sure you have distinct read – process – save chunks so you can see whats slowing you down and minimize cache misses.










(: