News for hackers. Stuff that matters.
Re:PostgreSQL Data Migration Tips by bhahn on Thursday March 19, 2015 @12:24PM (#9233000)

  FOR UPDATE NOWAIT immediately locks the rows being retrieved in the first step (as if they were to be updated)
Technically "FOR UPDATE" only makes an attempt to lock rows, and the "NOWAIT" instructs postgres, in the case that another transaction already has a lock on the row, to raise an error immediately instead of the default behavior of waiting for the lock to become available.

http://www.postgresql.org/docs/9.4/static/sql-select.html

Re:PostgreSQL Data Migration Tips by aanari on Thursday March 19, 2015 @12:53PM (#9233187)
That's a good clarification. I think it's better for the data migration to error out when acquiring the lock on rows and then retry, rather than waiting indefinitely, but YMMV (your mileage may vary).