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 whole thread)
Lists: pgsql-performance
Wouldn't it be the most portable solution to work with a domain?

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?

In response to


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-2015 The PostgreSQL Global Development Group