X-Original-To: pgsql-admin@postgresql.org Received: from localhost (unknown [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 3DC549251D9 for ; Thu, 22 May 2003 22:08:18 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 72058-04 for ; Thu, 22 May 2003 22:07:47 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id BB34D925747 for ; Thu, 22 May 2003 20:00:14 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4N00EU6012260; Thu, 22 May 2003 20:00:14 -0400 (EDT) To: Ernest E Vogelsinger Cc: "pgsql-admin" Subject: Re: Q: Structured index - which one runs faster? In-reply-to: <5.1.1.6.2.20030523013910.03095bb8@mail.vogelsinger.at> References: <5.1.1.6.2.20030522223909.05929600@mail.vogelsinger.at> <5.1.1.6.2.20030522223909.05929600@mail.vogelsinger.at> <5.1.1.6.2.20030523013910.03095bb8@mail.vogelsinger.at> Comments: In-reply-to Ernest E Vogelsinger message dated "Fri, 23 May 2003 01:43:06 +0200" Date: Thu, 22 May 2003 20:00:14 -0400 Message-ID: <12259.1053648014@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/326 X-Sequence-Number: 8888 Ernest E Vogelsinger writes: > Do you know if there's a general performance difference between numeric > (int4) and character (fixed-size char[5]) columns? The ident1 and ident2 > columns are planned to be char[5], only the third column (with least > precedence) will be numeric. int4 is certainly faster to compare than char(n), but I wouldn't contort your database design on that basis... if the idents aren't naturally integers, don't force them to be. regards, tom lane