Re: BUG #15600: ts_stat's nentry maxes out at 255 - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15600: ts_stat's nentry maxes out at 255
Date
Msg-id 14774.1548091862@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15600: ts_stat's nentry maxes out at 255  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15600: ts_stat's nentry maxes out at 255  (Christoph Gößmann <mail@goessmann.io>)
List pgsql-bugs
=?utf-8?q?PG_Bug_reporting_form?= <noreply@postgresql.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


pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15587: Partitions with ALTER TABLE ADD CONSTRAINT
Next
From: Christoph Gößmann
Date:
Subject: Re: BUG #15600: ts_stat's nentry maxes out at 255