Re: Performance: BigInt vs Decimal(19,0)

From: Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: "Yusuf W(dot)" <unicef2k(at)yahoo(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance: BigInt vs Decimal(19,0)
Date: 2003-09-29 14:59:27
Message-ID: 1064847566.690.15.camel@taz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Wouldn't it be the most portable solution to work with a domain?
CREATE DOMAIN BIG_NUMBER AS BIGINT;

If I use BIG_NUMBER everywhere I need it in my database, porting it to
other database products should be easy... any SQL 92 compliant dbms
should support domains.

On Sun, 2003-09-28 at 00:06, Josh Berkus wrote:

> Yusuf,
>
> > Does anyone know where I could get some documentation
> > on how the int and decimal are implemented so I could
> > prove to him that ints are better? Can people suggest
> > good points to make in order to prove it?
>
> RTFM:
> http://www.postgresql.org/docs/7.3/interactive/datatype.html#DATATYPE-NUMERIC

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Browne 2003-09-29 15:12:55 Re: avoiding seqscan?
Previous Message Shridhar Daithankar 2003-09-29 14:47:35 Re: TPC-R benchmarks