Index greater than 8k

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Index greater than 8k
Дата
Msg-id 454627F9.10805@commandprompt.com
обсуждение исходный текст
Ответ на Re: [GENERAL] NOTICE: word is too long INSERT 0 3014  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: [GENERAL] Index greater than 8k  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
Hello,

I recently posted about a word being too long with Tsearch2. That isn't
actually the problem I am trying to solve (thanks for the feedback
though, now I understand it).

The problem I am after is the 8k index size issue. It is very easy to
get a GIST index (especially when using tsearch2) that is larger than that.

Is recompiling the block size the option there?
What are the downsides, except for the custom build?

Joshua D. Drake

--

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
             http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: [PATCHES] WAL logging freezing
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: bug in on_error_rollback !?