I’m using PostgreSQL for my cryptocurrency exchange database, the question is: for saving currency amount (numbers) with their precision (like 323232323232323.45454545 ~ 23 digit + 1 dot: 15 digit before dot and 8 digit after that), Should I use
varchar(24) type for them or
double precision or
Note: It seems that
double precision type cant properly save big numbers like example above and it will be rounded to 323232323232323!
Witch one has better performance (speed) and needs less resources?