Prisma pgbouncer setting quadrupled query round-trips on Supabase for six months, KaribuKit finds
KaribuKit, a hotel booking system built by the operator of Mara Hilltop lodge, discovered that a misconfigured 'pgbouncer=true' setting in Prisma's Supabase connection had forced every database query to make four network round-trips instead of one since March. Fixing the setting cut the availability check on the booking page from 8.06 seconds to 1.88 seconds. The discovery came the same night the team also fixed an unrelated crash caused by an image preloader overwhelming memory on mobile Safari.