#git

1 post on this topic, newest first. all tags →

How we review pull requests that an agent wrote

By spring an agent was opening more than half of the pull requests on our main service. Our review process was built for people who understood their own diff, and it broke in specific ways. 'Read more carefully' didn't fix it. Changing what a PR has to contain before a person looks at it did.

code-reviewai-agentsengineering-practice+1 more

Jun 23, 20269 min11 min

~/tips/today — 2026-10-19

~cat tips/today

Never build an index on a live table without CONCURRENTLY

postgresqlmigrations

A plain CREATE INDEX takes a lock that blocks every write to the table for the whole build. On a big table that means minutes of outage that look like a hung app.

CREATE INDEX CONCURRENTLY orders_customer_idx ON orders (customer_id);

It's slower and can't run inside a transaction, so you'll have to tell your migration tool. If it fails halfway, it leaves an invalid index behind, so check pg_index.indisvalid and drop it before you retry.

↵ open y yesterday l ls /tips

esc close