On 29/09/2011 9:13 PM, Marti Raudsepp wrote:

How does decimal store the number internally,

Numeric is stored as binary-coded decimal. This isn't fast.

I'd say using a bigint is a no-brainer unless you think there's a chance you might exceed the maximum size for a 64-bit integer.

--
Craig Ringer

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to