Re: BUG #15600: ts_stat's nentry maxes out at 255

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mail(at)goessmann(dot)io
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #15600: ts_stat's nentry maxes out at 255
Date: 2019-01-21 17:31:02
Message-ID: 14774.1548091862@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?utf-8?q?PG_Bug_reporting_form?= <noreply(at)postgresql(dot)org> writes:
> Unexpected behaviour:
> netry for 'hello' results in 255 despite 'hello' occurs 539 times in the
> attached test.

I think this is a consequence of the MAXNUMPOS limitation in the source
code, ie an individual tsvector won't store more than 255 locations for
the same word. That's intentional to keep common words from bloating
tsvectors too much. But if it's documented anywhere, I didn't see it.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Christoph Gößmann 2019-01-21 18:38:49 Re: BUG #15600: ts_stat's nentry maxes out at 255
Previous Message Alvaro Herrera 2019-01-21 16:29:44 Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT