BUG #11901: Full text search: thesaurus size limit

From: louellet(at)nrcan(dot)gc(dot)ca
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11901: Full text search: thesaurus size limit
Date: 2014-11-06 16:48:14
Message-ID: 20141106164814.26930.82494@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11901
Logged by: Luc Ouellette
Email address: louellet(at)nrcan(dot)gc(dot)ca
PostgreSQL version: 9.3.4
Operating system: "PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu
Description:

I work for a national mapping agency and I am trying to build a thesaurus
dictionary loan 300000 lines.
When I go over 65535 lines the query aborts. This problem was already
reporter (see BUG # 7793: tsearch_data thesaurus size limit) and was
corrected with PG 9.2.2. This correction was not spread in the most recent
versions of postgresql.

My pgAdmin can compile a version corrected by updating the tsearch src /
backend / / dict_thesaurus.c
and use uint32 instead of uint16 entry's number in DictThesaurus.
This solution would oblige us to maintain a branch unofficial PostgreSQL and
this is not desirable.

Is it possible that this correction is to formalize and apply it permanently
on the next version of PostgreSQL?

Regards,
Luc Ouellette

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message lr 2014-11-06 18:01:15 BUG #11902: PostgreSQL 9.5 crashes on alter table in function
Previous Message Bruce Hunsaker 2014-11-06 14:29:49 Re: BUG #11883: Year 1500 not treated as leap year when it was a leap year