X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EB111D1E0B5 for ; Sun, 16 May 2004 14:13:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 76088-06 for ; Sun, 16 May 2004 14:12:56 -0300 (ADT) Received: from www.postgresql.com (www.postgresql.com [200.46.204.209]) by svr1.postgresql.org (Postfix) with ESMTP id 5CBDED1E18D for ; Sun, 16 May 2004 13:56:04 -0300 (ADT) Received: from bob.samurai.com (bob.samurai.com [205.207.28.75]) by www.postgresql.com (Postfix) with ESMTP id 47649CF6831 for ; Sat, 15 May 2004 23:28:32 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by bob.samurai.com (Postfix) with ESMTP id B79A31EB5; Sat, 15 May 2004 22:28:06 -0400 (EDT) Received: from bob.samurai.com ([127.0.0.1]) by localhost (bob.samurai.com [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 25671-01-4; Sat, 15 May 2004 22:28:05 -0400 (EDT) Received: from [192.168.1.101] (d226-89-59.home.cgocable.net [24.226.89.59]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by bob.samurai.com (Postfix) with ESMTP id 51CC21E2B; Sat, 15 May 2004 22:28:03 -0400 (EDT) Subject: Re: numeric data types From: Neil Conway To: Jaime Casanova Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Message-Id: <1084674467.25578.115.camel@tokyo> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Sat, 15 May 2004 22:27:47 -0400 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at mailbox.samurai.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200405/145 X-Sequence-Number: 6976 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