4 Commits
Author SHA1 Message Date
Tom Moor c0288df8eb fix: Reduce error noise while the database is read-only or unavailable (#14599)
* fix: Reduce error noise while the database is read-only or unavailable

* fix: Let websocket clients reconnect after a slow authentication
2026-11-15 12:40:59 -05:00
Tom Moor 2276ee2ecb Set lock_timeout on request transactions (#14563)
* 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
2026-11-12 21:51:48 -05:00
Tom Moor aaab59d8ca perf: Send statement timeout in the same round trip as transaction start (#13937)
* perf: Send statement timeout with the statement that begins a transaction

* chore: Upgrade pg to 8.23.0
2026-10-02 13:17:28 -04:00
Tom MoorandClaude Fable 5 2414bb3a84 perf: Search queries (#13293)
* 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>
2026-08-03 22:26:45 -04:00