Radim @ boringSQL on Mythryl: “Everyone says store money as numeric, not float. Fewer people can…”

Everyone says store money as numeric, not float. Fewer people can say what breaks if you don’t. Your float SUM changes every run. Same rows, nothing touched, three different totals. That’s floats plus parallel aggregation. #postgres boringsql.com/posts/same-r...

boringsql.comSame rows, different SUMSame query, same rows, different SUM totals in PostgreSQL. The culprit is parallel aggregation over double precision floats, not a bug. Here is the mechanism and the fix.

29/6/26, 6:10 am0 reposts0 likes