BUG #7793: tsearch_data thesaurus size limit

From: davios(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7793: tsearch_data thesaurus size limit
Date: 2013-01-06 16:23:55
Message-ID: E1Trt0t-000855-VP@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: 7793
Logged by: David Boutin
Email address: davios(at)gmail(dot)com
PostgreSQL version: 9.1.7
Operating system: Ubuntu 12.04 LTS 64bits
Description:

Hi all,

I like working with thesaurus files with specific text search configuration
to ease search with synonyms.
Today I tried to create a thesaurus of artist names (using musicbrainz
database) including their synonyms/aliases.

This thesaurus file is about 1M lines.

And I realized it is impossible to use it with FTS, I got unexpected error
with "plainto_tsquery" and even segmentation fault for some names according
to postgresql log file.
I then tried to reduce the size of this file several times to arrive to a
final file of 65535 lines which works fine whereas a 65536 lines file crash
my queries.

Is there any way to increase this thesaurus size limit?

Many thanks in advance for your help

Kind regards
David

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message s.reiser 2013-01-06 20:09:34 BUG #7794: pg_dump: errors when using pipes/streams
Previous Message emesika 2013-01-06 13:45:01 BUG #7792: pg_dump does not treat -c flag correctly when using tar format