Index greater than 8k - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Index greater than 8k
Date
Msg-id 454627F9.10805@commandprompt.com
Whole thread Raw
In response to Re: [GENERAL] NOTICE: word is too long INSERT 0 3014  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: [GENERAL] Index greater than 8k  (Teodor Sigaev <teodor@sigaev.ru>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [PATCHES] WAL logging freezing
Next
From: "Jim C. Nasby"
Date:
Subject: Re: bug in on_error_rollback !?