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
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
discussing the alternatives. Personally, I would use bigint since it
should su
