pgsql: Doc: clean up documentation about text search datatype limits.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Doc: clean up documentation about text search datatype limits.
Date: 2026-08-17 22:18:09
Message-ID: E1ww5ei-00000000ybA-1Gkd@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Doc: clean up documentation about text search datatype limits.

textsearch.sgml neglected to mention that the MAXSTRPOS total-length
limit applies to tsquery as well as tsvector. It also claims that
there is a 32K limit on the total number of nodes in a tsquery, which
is wrong. (I suspect that QueryOperator.left may once have been
int16, which would give rise to such a limit. But it's uint32 now,
so you'd hit the 1GB varlena limit well before overflowing that.)

While at it, re-order the bullet points into an order that makes
more sense, to me anyway.

Reported-by: Claude Code (via Noah Misch)
Author: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Reviewed-by: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>
Discussion: https://postgr.es/m/455079.1786897319@sss.pgh.pa.us
Backpatch-through: 14

Branch
------
REL_15_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/38e933fafac4db530817571570ef4f550529ffe1

Modified Files
--------------
doc/src/sgml/textsearch.sgml | 21 ++++++++-------------
1 file changed, 8 insertions(+), 13 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2026-08-18 01:06:34 pgsql: pg_locale.c: Fix REL_18_STABLE for srclen < 0.
Previous Message Peter Geoghegan 2026-08-17 21:31:27 pgsql: GiST: Deprecate F_TUPLES_DELETED opaque area flag.