Performance: BigInt vs Decimal(19,0)

From: "Yusuf W(dot)" <unicef2k(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Performance: BigInt vs Decimal(19,0)
Date: 2003-09-27 23:54:14
Message-ID: 20030927235414.54467.qmail@web40405.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-09-28 00:26:09 Re: Performance: BigInt vs Decimal(19,0)
Previous Message Ron Johnson 2003-09-27 19:53:51 Re: advice on raid controller