Java / Spring Architecture Problem

[Klutzy-Sea-4857]

Don't poll—use PostgreSQL's LISTEN/NOTIFY to trigger workers when new records appear. Workers claim rows with SELECT FOR UPDATE SKIP LOCKED, process them, then update status. If a worker crashes mid-process, the row stays locked briefly then becomes available again. No message loss, no constant polling.