* Set lock_timeout on request transactions
Lock waits in API transactions now fail after 5s with a 503 instead of
holding a pool connection until the statement timeout.
* Map query timeouts to request_timeout in batch sub-requests
* perf: Add team-scoped composite index for document search
The global tsvector GIN index scanned matches across all teams before
filtering by teamId. A composite (teamId, searchVector) index via
btree_gin confines the scan to a single team's documents.
* fix: Bound search queries with the request statement timeout
Search queries ran outside a transaction and so never received the
SET LOCAL statement_timeout applied to request-handling processes,
leaving cancelled requests running unbounded on the database.
* Bind queries to read-only replica where available
* Remove readOnly option for now
---------
Co-authored-by: Claude Fable 5 <noreply@anthropic.com>