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 A88AAD1D0B6 for ; Fri, 5 Mar 2004 14:07:37 +0000 (GMT) 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 30111-02 for ; Fri, 5 Mar 2004 10:07:38 -0400 (AST) Received: from internet.potentialtech.com (h-66-167-251-6.PHLAPAFG.covad.net [66.167.251.6]) by svr1.postgresql.org (Postfix) with ESMTP id 5737FD1CAD1 for ; Fri, 5 Mar 2004 10:07:34 -0400 (AST) Received: from potentialtech.com (pa-plum1c-102.pit.adelphia.net [24.53.179.102]) by internet.potentialtech.com (Postfix) with ESMTP id 9927669A39; Fri, 5 Mar 2004 09:07:37 -0500 (EST) Message-ID: <404889A6.7@potentialtech.com> Date: Fri, 05 Mar 2004 09:07:34 -0500 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jeff Cc: pgsql-performance@postgresql.org Subject: Re: Fixed width rows faster? References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/61 X-Sequence-Number: 5917 Jeff wrote: > I'm guessing the answer to this is "no" > > Is there any performance advantage to using a fixed width row (with PG)? No. The user docs state that the performance is equal for char, varchar and text. > I've heard this theory a few times and I think it is based on older, > different databases MySQL used to have this issue (I don't know if it still does or not) to the point that the docs once claimed that an index on a varchar was barely as fast as a char with no index at all. > and we have also some custom software here that uses > fixed width rows to be able to hit row N in O(1), but that isn't what > I'd call a real database. Isn't needed in modern versions of Postgres, but I don't know (historically) if it ever was or not. -- Bill Moran Potential Technologies http://www.potentialtech.com