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
Gregor
On Thu, 2011-09-29 at 14:15 +0200, Gregor Vollmer wrote:
> Dear List,
>
> we are currently updating our application to use multiple database
> backends, the main backend on our site will be Postgres, though.
>
> Some of our columns exceed the limit of the 'integer' type, now we are
>
On Thu, Sep 29, 2011 at 15:15, Gregor Vollmer
wrote:
> We do not do any arithmetic on the columns, only saving and retrieval, is
> decimal as fast as bigint in that case?
It's slightly slower because numeric is passed around by pointer, not
by value. Bigint is by-value in 64-bit Postgres versions
