2ndQuadrant has a good write up of what is required to make sure you don't fall into any traps: https://blog.2ndquadrant.com/what-is-select-skip-locked-for-...
Now if we're just talking about persisting data to somewhere - postgres COPY is pretty amazing.