Btree index on varchar

From: Alexaki Sofia <alexaki(at)ics(dot)forth(dot)gr>
To: pgsql-sql(at)postgresql(dot)org
Subject: Btree index on varchar
Date: 2001-03-23 10:59:14
Message-ID: Pine.GSO.4.10.10103231252380.8056-100000@sappho.ics.forth.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jens Philipsen 2001-03-23 13:10:26 Hi there, having problems with the following:
Previous Message datactrl 2001-03-23 09:10:16 SOME PL/PGSQL PROBLEMS