BUG #11901: Full text search: thesaurus size limit

Started by Nonameover 11 years ago2 messagesbugs
Jump to latest
#1Noname
louellet@nrcan.gc.ca

The following bug has been logged on the website:

Bug reference: 11901
Logged by: Luc Ouellette
Email address: louellet@nrcan.gc.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

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #11901: Full text search: thesaurus size limit

louellet@nrcan.gc.ca writes:

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.

I see no indication that anything was ever done about that report, either
in 9.2 or any other branch :-(

regards, tom lane

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs