Postgres Pro
Downloads
Home   >   mailing lists

Re: numeric data types - Mailing list pgsql-performance

From Tom Lane
Subject Re: numeric data types
Date
Msg-id 3209.1084593796@sss.pgh.pa.us
Whole thread Raw
In response to numeric data types  ("Jaime Casanova" <el_vigia_ec@hotmail.com>)
List pgsql-performance
Tree view 
"Jaime Casanova" <el_vigia_ec@hotmail.com> writes:
> i have a question, is there any advantages in using numeric(1) or numeric(2)
> in place of smallint?

Performance-wise, smallint is an order of magnitude better.

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jaime Casanova"
Date:
Subject: numeric data types
Next
From: Tom Lane
Date:
Subject: Re: TPCH 100GB - need some help