Postgres Pro
Downloads
Home   >   mailing lists

Varchar Indexing - Mailing list pgsql-general

From mitch
Subject Varchar Indexing
Date
Msg-id Pine.BSF.4.32.0102081604260.64784-100000@servbox.venux.net
Whole thread Raw
Responses Re: Varchar Indexing
List pgsql-general
Tree view 
Is there a size limit on indexable varying character fields?

I need a semi-large varchar field (say 2048 characters) but really need
the speed of an index in searching, I'm left wondering at what point
indexing varchar fields becomes useless (if it ever does)..

Thanks!

-Mitch

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fw: [PHP] Fooling the query optimizer
Next
From: "Brent R.Matzelle"
Date:
Subject: Indicies and write performance