Home > mailing lists

Btree index on varchar - Mailing list pgsql-sql

From	Alexaki Sofia
Subject	Btree index on varchar
Date	March 23, 2001 06:35:33
Msg-id	Pine.GSO.4.10.10103231252380.8056-100000@sappho.ics.forth.gr Whole thread Raw
Responses	Re: Btree index on varchar
List	pgsql-sql

Tree view

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

pgsql-sql by date:

From: "datactrl"
Date: 23 March 2001, 05:25:42
Subject: SOME PL/PGSQL PROBLEMS

From: "postgresql"
Date: 23 March 2001, 08:09:37
Subject: Re: creating "job numbers"

Btree index on varchar - Mailing list pgsql-sql

Previous

Next