Optimizing PostgreSQL Update Statements for Large Datasets and Missing Values

Locking MySQL Select Row Until UPDATE Has Been Ran On It?