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

Поиск
Список
Период
Сортировка
От Mitch Vincent
Тема Re: Speaking of Indexing... (Text indexing)
Дата
Msg-id 003001c0c29c$b46b6e00$0b51000a@epox450
обсуждение исходный текст
Ответ на Re: Speaking of Indexing... (Text indexing)  (Thomas Lockhart <lockhart@alumni.caltech.edu>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: age() function documentation
Следующее
От: Jean-Eric Cuendet
Дата:
Сообщение: Postgres & Kerberos