Re: NOTICE: word is too long INSERT 0 3014

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: NOTICE: word is too long INSERT 0 3014
Date: 2006-10-30 08:25:08
Message-ID: 4545B6E4.4000904@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

> I am running into this limitation ALOT with Tsearch2. What are my
> options to get around it. Do I have to compile PostgreSQL with a
> different block size?
>
> If yes, what are the downsides to doing so (outside of not being able to
> do straight upgrades)?

If you really need that, your should play around WordEntry definition
(tsvector.h). Sorry, right now I haven't possibility to look closer,
just tomorrow.
Limit for word is equal 2KB - I supposed that is long enough to store
any meaningful words.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2006-10-30 08:37:57 Re: Replicating changes
Previous Message louis gonzales 2006-10-30 07:30:04 Re: postgresql books and convertion utilities

Browse pgsql-hackers by date

  From Date Subject
Next Message Алексей Заяц 2006-10-30 09:43:43 Re: BUG #2724: Could not check connection status with "ssl=on"
Previous Message Tom Lane 2006-10-29 17:57:28 Re: Build of postgresql 8.2 beta 2 failure