Same rows, different SUM

This blog post by Radim Marek discusses the complexities and non-determinism of summing floating-point numbers in databases, particularly in contexts where parallel processing is involved. It delves into how floating-point arithmetic can yield different results across multiple runs due to the order of operations and the way parallel sums are executed. The author urges developers to consider using exact numeric types for total calculations that require precision, emphasizing that while parallelism can improve performance, it can also expose the inherent inaccuracies of floating-point calculations.