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 8BD95565CD for ; Mon, 14 Mar 2005 15:59:15 +0000 (GMT) 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 66047-10 for ; Mon, 14 Mar 2005 15:59:14 +0000 (GMT) Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227]) by svr1.postgresql.org (Postfix) with ESMTP id EEF415644C for ; Mon, 14 Mar 2005 15:59:11 +0000 (GMT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1DAry4-0002E5-00; Mon, 14 Mar 2005 10:58:56 -0500 To: =?iso-8859-1?q?Miroslav_=A9ulc?= Cc: Christopher Kings-Lynne , John Arbash Meinel , PGSQL mailing list Subject: Re: How to read query plan References: <42345D24.8070104@startnet.cz> <4234692E.3050802@arbash-meinel.com> <42347407.2000202@startnet.cz> <42347D5E.9000900@arbash-meinel.com> <42348F54.1000408@startnet.cz> <423493E5.6040203@arbash-meinel.com> <42355249.8090101@startnet.cz> <4235533E.8040100@familyhealth.com.au> <423554D2.9000207@startnet.cz> In-Reply-To: <423554D2.9000207@startnet.cz> From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 14 Mar 2005 10:58:55 -0500 Message-ID: <877jkauslc.fsf@stark.xeocode.com> Lines: 9 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.3 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.014 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/264 X-Sequence-Number: 10969 Miroslav Šulc writes: > I think so. I'll change the varchar(1) fields to char(1) where possible char isn't faster than varchar on postgres. If anything it may be slightly slower because every comparison first needs to pad both sides with spaces. -- greg