Skip to content

Glossary: PostgreSQL Beyond the Basics

SKIP LOCKED, NOWAIT

Also written: SKIP LOCKED, NOWAIT, work queue

Options for `FOR UPDATE`. `SKIP LOCKED` skips rows other sessions have locked, so packers each get a different order. `NOWAIT` fails at once instead of waiting.

Where the book teaches it

Related terms

FOR UPDATE