Post

Are AI agents over-indexing the schemas they create? First it was a hunch. Then I had to verify it. And there was it! Every agent dumps its indexes onto the single table taking all the writes. boringsql.com/posts/unbear...

boringsql.comThe unbearable lightness of one more indexThirty PostgreSQL schemas written by coding agents, loaded and measured. The indexes are competent; the cumulative cost is not.

11/9/26, 6:24 pm0 reposts1 like

Radim @ boringSQL

@boringsql.com

11 Sept

The part I didn't expect: four words at the end of a prompt. Adding "make it production-ready" bought more indexes! Were those indexes wrong? No - they would pass regular PR review. Except their impact on maintenance. Writes going up and vacuum taking longer every week. #postgresql #vibecoding