News for hackers. Stuff that matters.

A comment on Understanding Ethereum Smart Contracts. Parent comment

Re:Understanding Ethereum Smart Contracts by anarazel on Wednesday November 29, 2017 @06:54PM (#15812053)
You know there's a numeric type in postgres? Not quite arbitrary precision, but large enough for pretty all practical purposes "up to 131072 digits before the decimal point; up to 16383 digits after the decimal point"

https://www.postgresql.org/docs/current/static/datatype-nume...

[ Parent | on HN ]
Re:Understanding Ethereum Smart Contracts by tatersolid on Saturday December 02, 2017 @09:26AM (#15831940)
NUMERIC (without a precision or scale) is a variable-length datatype, and suffers all the performance problems mentioned above.

If you specify a precision and scale, performance of NUMERIC improves quite a bit, but now you can’t store values with vastly different magnitudes (USD and JPY) in the same column without wasting tons of storage on each row. You’re back to square one.

[ Parent | on HN ]