X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id A0AE6D1B51D for ; Mon, 29 Sep 2003 15:00:17 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 00698-02 for ; Mon, 29 Sep 2003 11:59:45 -0300 (ADT) Received: from lucifer.oficina (unknown [200.69.203.237]) by svr1.postgresql.org (Postfix) with ESMTP id 86562D1B535 for ; Mon, 29 Sep 2003 11:59:44 -0300 (ADT) Received: from [192.168.1.174] (taz.oficina [192.168.1.174] (may be forged)) (authenticated bits=0) by lucifer.oficina (8.12.9/8.12.9) with ESMTP id h8TEuBv2026796; Mon, 29 Sep 2003 11:56:11 -0300 (ART) (envelope-from franco@akyasociados.com.ar) Subject: Re: Performance: BigInt vs Decimal(19,0) From: Franco Bruno Borghesi To: Josh Berkus Cc: "Yusuf W." , "pgsql-performance@postgresql.org" In-Reply-To: <200309272006.42462.josh@agliodbs.com> References: <20030928023936.66818.qmail@web40408.mail.yahoo.com> <200309272006.42462.josh@agliodbs.com> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-pHKcHuJ2SHi09Kwy+Rr5" Organization: AK y Asociados S.R.L. Message-Id: <1064847566.690.15.camel@taz> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Mon, 29 Sep 2003 11:59:27 -0300 X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/357 X-Sequence-Number: 3723 --=-pHKcHuJ2SHi09Kwy+Rr5 Content-Type: multipart/alternative; boundary="=-HDPLPISq7frl/BaUncIx" --=-HDPLPISq7frl/BaUncIx Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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, >=20 > > 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? >=20 > RTFM: > http://www.postgresql.org/docs/7.3/interactive/datatype.html#DATATYPE-NUM= ERIC --=-HDPLPISq7frl/BaUncIx Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable 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 othe= r database products should be easy... any SQL 92 compliant dbms should supp= ort 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.h=
tml#DATATYPE-NUMERIC
--=-HDPLPISq7frl/BaUncIx-- --=-pHKcHuJ2SHi09Kwy+Rr5 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (FreeBSD) iD8DBQA/eEjO21dVnhLsBV0RAl3RAKCEVcENTcRP/pyK4o8ztX9NBlvvhwCfXaku PnVAHb3cLSmhIc77kXH0K4Y= =CyhK -----END PGP SIGNATURE----- --=-pHKcHuJ2SHi09Kwy+Rr5--