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 2B277D1B511 for ; Sat, 27 Sep 2003 23:54:42 +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 26826-01 for ; Sat, 27 Sep 2003 20:54:14 -0300 (ADT) Received: from web40405.mail.yahoo.com (web40405.mail.yahoo.com [66.218.78.102]) by svr1.postgresql.org (Postfix) with SMTP id 49449D1B509 for ; Sat, 27 Sep 2003 20:54:11 -0300 (ADT) Message-ID: <20030927235414.54467.qmail@web40405.mail.yahoo.com> Received: from [66.185.84.75] by web40405.mail.yahoo.com via HTTP; Sat, 27 Sep 2003 16:54:14 PDT Date: Sat, 27 Sep 2003 16:54:14 -0700 (PDT) From: "Yusuf W." Subject: Performance: BigInt vs Decimal(19,0) To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/341 X-Sequence-Number: 3707 For the application that I'm working on, we want to use data types that are database independent. (most databases has decimal, but not big int). Anyhow, we are planning on using decimal(19,0) for our primary keys instead of a big int, would there be a performance difference in using a bigint over using decimals? __________________________________ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com