Received: from ext1.ics.forth.gr (mailgate.ics.forth.gr [139.91.1.2]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2NB3Ow23900 for ; Fri, 23 Mar 2001 06:03:45 -0500 (EST) (envelope-from alexaki@ics.forth.gr) Received: from ismene.ics.forth.gr (mailhost.ics.forth.gr [139.91.157.51]) by ext1.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.5-GATE) with ESMTP id NAA00870 for ; Fri, 23 Mar 2001 13:02:53 +0200 (EET) Received: from sappho.ics.forth.gr (sappho-lane.ics.forth.gr [139.91.157.50]) by ismene.ics.forth.gr (8.8.8/ICS-FORTH/V3) with ESMTP id MAA21454 for ; Fri, 23 Mar 2001 12:59:44 +0200 (EET) Posted-Date: Fri, 23 Mar 2001 12:59:44 +0200 (EET) Organization: Received: from localhost (alexaki@localhost) by sappho.ics.forth.gr (8.9.3/ICS-FORTH/V8.2.2C-INTNULL) with ESMTP id MAA08388 for ; Fri, 23 Mar 2001 12:59:14 +0200 (EET) X-Authentication-Warning: sappho.ics.forth.gr: alexaki owned process doing -bs Date: Fri, 23 Mar 2001 12:59:14 +0200 (EET) From: Alexaki Sofia To: pgsql-sql@postgresql.org Subject: Btree index on varchar Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200103/458 X-Sequence-Number: 2126 Hello, I have a question for Btree indexes on a varchar field. Does postgres (7.0.2) uses a special encoding when creating Btree indexes on varchar?? Is it much more efficient to create indexes on integer than on strings with average length 30 chars?? Thank you in advance for your help Regards Sofia Alexaki