X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C632E14B287A for ; Mon, 9 Aug 2004 00:05:16 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43184-08 for ; Mon, 9 Aug 2004 03:05:11 +0000 (GMT) Received: from ganymede.hub.org (u46n208.hfx.eastlink.ca [24.222.46.208]) by svr1.postgresql.org (Postfix) with ESMTP id 49B5F14B28BB for ; Mon, 9 Aug 2004 00:04:45 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id 3755934E91; Mon, 9 Aug 2004 00:04:37 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id 31286346BC for ; Mon, 9 Aug 2004 00:04:37 -0300 (ADT) X-Return-Path: X-Received: from localhost ([unix socket]) by ganymede.hub.org (Cyrus v2.2.6) with LMTPA; Thu, 05 Aug 2004 15:13:37 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (localhost.hub.org [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id B5D783CBC0 for ; Thu, 5 Aug 2004 15:11:15 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by localhost with IMAP (fetchmail-6.2.5) for scrappy@localhost (single-drop); Thu, 05 Aug 2004 15:11:15 -0300 (ADT) X-Received: from svr1.postgresql.org ([unix socket]) by svr1.postgresql.org (Cyrus v2.2.6) with LMTPA; Thu, 05 Aug 2004 15:10:09 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id ED4D2D1B252 for ; Thu, 5 Aug 2004 15:10:08 -0300 (ADT) X-Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44853-06 for ; Thu, 5 Aug 2004 18:10:06 +0000 (GMT) X-Received: from mproxy.gmail.com (rproxy.gmail.com [64.233.170.193]) by svr1.postgresql.org (Postfix) with ESMTP id 5D8EED1B1C9 for ; Thu, 5 Aug 2004 15:10:02 -0300 (ADT) X-Received: by mproxy.gmail.com with SMTP id 73so18212rnk for ; Thu, 05 Aug 2004 11:10:01 -0700 (PDT) X-Received: by 10.38.9.22 with SMTP id 22mr62172rni; Thu, 05 Aug 2004 11:10:01 -0700 (PDT) Message-ID: <5cfdfaf7040805111013a769af@mail.gmail.com> Date: Thu, 5 Aug 2004 13:10:01 -0500 From: Jim Thomason Reply-To: jim@jimandkoka.com To: psql-performance@postgresql.org Subject: performance with column orders Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-DCC: : X-Spam-Pyzor: ReSent-Date: Mon, 9 Aug 2004 00:04:31 -0300 (ADT) Resent-From: "Marc G. Fournier" Resent-To: pgsql-performance@postgresql.org ReSent-Subject: performance with column orders ReSent-Message-ID: <20040809000431.L52647@ganymede.hub.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/109 X-Sequence-Number: 7745 I couldn't track down recent info in the archives, so I figured I'd ask here. Does the order of columns still have an impact on table speed? Back in the olden days, it used to be that fixed width columns (integer, tinyint, etc.) should be the first ("left") columns in the table and variable width ones should be towards the end ("right"). This allowed a database to line up the columns better on disk and give you a speed boost. So, does Postgres still care about it? And, if so, how much? The posts I found were from 2 years ago, and indicated that there is a minor increase, but not a lot. Incidentally, could anyone quantify that in any fashion? Thanks, -Jim....