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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general