Re: Speaking of Indexing... (Text indexing) - Mailing list pgsql-hackers

From Mitch Vincent
Subject Re: Speaking of Indexing... (Text indexing)
Date
Msg-id 003001c0c29c$b46b6e00$0b51000a@epox450
Whole thread Raw
In response to Re: Speaking of Indexing... (Text indexing)  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: age() function documentation
Next
From: Jean-Eric Cuendet
Date:
Subject: Postgres & Kerberos