Asked our agent to index a column on orders.
It wrote CREATE INDEX without CONCURRENTLY.
In dev: 2ms. In prod: 80M rows, lock queue HOL blocking, 500 pool sockets dead in 4s.
AI writes SQL for 10 rows, not 10 million.
The Migration Lockout: https://t.co/74cgCuV5gA
Asked our agent to index a column on orders.
It wrote CREATE INDEX without CONCURRENTLY.
In dev: 2ms. In prod: 80M rows, lock queue HOL blocking, 500 pool sockets dead in 4s.
AI writes SQL for 10 rows, not 10 million.
The Migration Lockout: https://t.co/74cgCuV5gA
Ran into @MetaVixensNFT on the timeline and @theinkedminkNFT is talented!
love the arts nd she gifted me Rosie!
Love the look! Epic artist and community! Join us!