Re: Speaking of Indexing... (Text indexing)

Mitch Vincent <mitch@venux.net>

From: "Mitch Vincent" <mitch@venux.net>
To: <pgsql-general@postgresql.org>
Cc: <pgsql-hackers@postgresql.org>
Date: 2001-04-11T15:33:06Z
Lists: pgsql-hackers, pgsql-general
> Hmm. I'm pretty sure that a single index on the entire contents of a
> resume *as a single field* is close to useless. And an index on an 8k
> piece is also useless. Presumably you really want an index covering each
> significant word of each resume, in which case you would not run into
> the 4k limit (or 2k limit? it is documented somewhere) on the size of an
> *index* field (which is still a limitation on PostgreSQL built with the
> standard 8k block size. Of course, you can build with a larger block
> size).

Just an FYI..

I asked the other day and someone (Tom?) told me it was about 2k.. 

-Mitch