PostgreSQL 9.5 introduced one of the powerful feature called SKIP LOCKED which is used for SKIP uncommitted data. I am not going to make this more complex topic, explaining by one practical example. In our project we have implemented thread mechanism. Different threads are running and taking a fixed set of records from the Database. … Continue reading PostgreSQL 9.5: Using FOR UPDATE SKIP LOCKED Option SELECT only Committed Records