Performance: BigInt vs Decimal(19,0) - Mailing list pgsql-performance

From Yusuf W.
Subject Performance: BigInt vs Decimal(19,0)
Date
Msg-id 20030927235414.54467.qmail@web40405.mail.yahoo.com
Whole thread Raw
Responses Re: Performance: BigInt vs Decimal(19,0)
List 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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: advice on raid controller
Next
From: Tom Lane
Date:
Subject: Re: Performance: BigInt vs Decimal(19,0)