Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3954D475D12 for ; Wed, 2 Oct 2002 14:01:37 -0400 (EDT) Received: from lsh114.siteprotect.com (lsh114.siteprotect.com [66.113.130.247]) by postgresql.org (Postfix) with ESMTP id 8698E475D00 for ; Wed, 2 Oct 2002 14:01:36 -0400 (EDT) Received: from bethvizx (252.dsl.seattle.telisphere.com [209.191.188.252]) by lsh114.siteprotect.com (8.9.3/8.9.3) with ESMTP id NAA20543; Wed, 2 Oct 2002 13:01:12 -0500 From: "Beth Gatewood" To: , "'Bruce Momjian'" Cc: Subject: Re: indexing on char vs varchar Date: Wed, 2 Oct 2002 11:01:07 -0700 Message-ID: <000901c26a3d$af524930$0c00000a@bethvizx> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2911.0) In-Reply-To: <200210021056.19128.josh@agliodbs.com> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/27 X-Sequence-Number: 9745 Thanks for the excellent description, Josh. And the reminder of the performance list (it's existence somehow slipped from my mind). -Beth > -----Original Message----- > From: Josh Berkus [mailto:josh@agliodbs.com] > Sent: Wednesday, October 02, 2002 10:56 AM > To: Beth Gatewood; 'Bruce Momjian' > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] indexing on char vs varchar > > > Beth, > > Oh, and you should take this sort of question to the new > performance list: > pgsql-performance-request@postgresql.org > > -- > -Josh Berkus > Aglio Database Solutions > San Francisco >