3 ms·
A decimal type is sometimes orders of magnitude slower than integer do simple stuff like summing (at least in Postgres and Python). This comes into play if you
by hansonkd 2y ago
A decimal type is sometimes orders of magnitude slower than integer do simple stuff like summing (at least in Postgres and Python).
This comes into play if you have to do aggregate functions across tens of thousands of rows and can kill performance compared to integers.