Re: NOTICE: word is too long INSERT 0 3014 - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: NOTICE: word is too long INSERT 0 3014
Date
Msg-id 45461B74.1030704@sigaev.ru
Whole thread Raw
In response to Re: NOTICE: word is too long INSERT 0 3014  (Teodor Sigaev <teodor@sigaev.ru>)
List pgsql-general
For example, redefine by follow way:

typedef struct
{
     uint32
                 haspos:1,
                 len:31;
     uint32      pos;
}   WordEntry;

/* <= 1Gb */
#define MAXSTRLEN ( 1<<30 )
#define MAXSTRPOS ( 1<<30 )

Teodor Sigaev wrote:
>> 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.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org/

--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: log_duration and JDBC V3 Preparded Statements
Next
From: "Leonel Nunez"
Date:
Subject: 8.1.5 RPMS