Re: [HACKERS] Remove 1MB size limit in tsvector - Mailing list pgsql-hackers

From Robert Haas
Subject Re: [HACKERS] Remove 1MB size limit in tsvector
Date
Msg-id CA+TgmoY2qxp7HBpDKQAsNDYn45cBRGOfjbmPmVx0=zfkx4GNjg@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Remove 1MB size limit in tsvector  (Ildus Kurbangaliev <i.kurbangaliev@postgrespro.ru>)
Responses Re: [HACKERS] Remove 1MB size limit in tsvector  (Ildus K <i.kurbangaliev@postgrespro.ru>)
List pgsql-hackers
On Tue, Aug 1, 2017 at 10:08 AM, Ildus Kurbangaliev
<i.kurbangaliev@postgrespro.ru> wrote:
> Historically tsvector type can't hold more than 1MB data.
> I want to propose a patch that removes that limit.
>
> That limit is created by 'pos' field from WordEntry, which have only
> 20 bits for storage.
>
> In the proposed patch I removed this field and instead of it I keep
> offsets only at each Nth item in WordEntry's array.

So this would break pg_upgrade for tsvector columns?

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] pgbench minor doc typo
Next
From: Dave Cramer
Date:
Subject: [HACKERS] JDBC 42.1.4 released