// 03 / writing
writing
- oct 16, 2026·4 min read
Doris json_search was quadratic on arrays. I sent the fix upstream.
A 2 MB JSON document took 18.5 seconds to search in Apache Doris. JSONB arrays have no offset table, and the loop asked for the length and the i-th element on every iteration. The fix is merged into apache/doris.
dorisc++open-sourceperformancejson - sep 16, 2026·2 min read
Finding a psycopg connection leak in executor threads
A pod restarted after the pool hit 50. close_old_connections() ran on the request thread. Each ThreadPoolExecutor worker took a lease and never gave it back.
postgrespsycopgdjangopooling - jun 02, 2026·3 min read
We removed a column. EU went offline.
DROP COLUMN shipped in the same deploy as the code that stopped reading it. Old pods kept serving traffic against the new schema. EU had zero healthy replicas for about four minutes.
postgresmigrationsincidentkubernetes - feb 12, 2026·4 min read
Postgres had an index. It still sequential-scanned 1.7 million rows.
The investigations list took 30-40 seconds. We optimized that query first. The real load was a quota check doing a sequential scan on 1.7 million rows because the composite index was in the wrong order.
postgresindexesperformancerds