Varchar Indexing

From: mitch <mitch(at)venux(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Varchar Indexing
Date: 2001-02-08 21:04:38
Message-ID: Pine.BSF.4.32.0102081604260.64784-100000@servbox.venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2001-02-08 21:07:15 Re: [GENERAL] Re: full text searching
Previous Message Raymond Chui 2001-02-08 19:43:00 How to make PostgreSQL JDBC drive get PGTZ?