Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group