Any match distance for large documents can result in search errors

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: magicagent(at)gmail(dot)com
Subject: Any match distance for large documents can result in search errors
Date: 2025-09-15 15:25:22
Message-ID: 175794992266.852.6874458445416625589@wrigleys.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/17/textsearch-limitations.html
Description:

Any match distance in a <N> (FOLLOWED BY), tsquery for documents with more
than 16,383 words, can result in a false positive or a false negative
result.

For N = 1 (normal phrase search) this limitation is a lot more restrictive
than N > 16,384

See
https://www.postgresql.org/message-id/17569-47d11a72a38bf8ae%40postgresql.org

Browse pgsql-docs by date

  From Date Subject
Next Message Eugen Konkov 2025-09-16 20:55:58 Re: The document contains false statements
Previous Message David G. Johnston 2025-09-13 23:26:21 Re: The document contains false statements