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