Decimal vs. Bigint memory usage

From: Gregor Vollmer <vollmer(at)ekp(dot)uni-karlsruhe(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Decimal vs. Bigint memory usage
Date: 2011-09-29 12:15:07
Message-ID: 4E84614B.40104@ekp.uni-karlsruhe.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 suffice in most cases, but using decimal is under discussion,
too, because our modules would be able to precisely specify their
required column sizes.

We do not do any arithmetic on the columns, only saving and retrieval,
is decimal as fast as bigint in that case?

How does decimal store the number internally, is it a fixed size
through-out all rows and how does it compare to bigint?

Thanks in advance,
Gregor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message senthilnathan 2011-09-29 12:26:37 pg_stat_replication data in standy servers
Previous Message Radosław Smogura 2011-09-29 11:12:56 Re: bytea columns and large values