Re: numeric data types - Mailing list pgsql-performance

From Neil Conway
Subject Re: numeric data types
Date
Msg-id 1084674467.25578.115.camel@tokyo
Whole thread Raw
In response to numeric data types  ("Jaime Casanova" <el_vigia_ec@hotmail.com>)
List pgsql-performance
On Fri, 2004-05-14 at 17:08, Jaime Casanova wrote:
> is there any diff. in performance if i use smallint in place of integer?

Assuming you steer clear of planner deficiencies, smallint should be
slightly faster (since it consumes less disk space), but the performance
difference should be very small. Also, alignment/padding considerations
may mean that smallint doesn't actually save any space anyway.

-Neil



pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: TPCH 100GB - need some help
Next
From: Duane Lee - EGOVX
Date:
Subject: Hardware Platform