Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Index greater than 8k
- From: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- To: "Joshua D. Drake" <jd(at)commandprompt(dot)com>
- Cc: PgSQL General <pgsql-general(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
- Subject: Index greater than 8k
- Date: Mon, 30 Oct 2006 08:27:37 -0800
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
- Follow-Ups:
- Re: [GENERAL] Index greater than 8k
- From: Teodor Sigaev
- Re: [GENERAL] Index greater than 8k
- References:
- Re: [GENERAL] NOTICE: word is too long INSERT 0 3014
- From: Joshua D. Drake
- Re: [GENERAL] NOTICE: word is too long INSERT 0 3014
- Prev by Date: Re: [PATCHES] WAL logging freezing
- Next by Date: Re: bug in on_error_rollback !?
- Previous by thread: Re: [GENERAL] NOTICE: word is too long INSERT 0 3014
- Next by thread: Re: [GENERAL] Index greater than 8k
- Indexes: