Soft upper limit of the size of the set returned by GIN index scans.
At a glance
| Property | Value |
|---|---|
| Parameter | gin_fuzzy_search_limit |
| Category | Client Connection Defaults |
| Default | (see documentation) |
| Value type | integer |
| Change scope | Per-session (SET) |
| Available in | PostgreSQL 12, 13, 14, 15, 16, 17, 18, 19 (added in 12) |
What it does
Soft upper limit of the size of the set returned by GIN index scans. For more information see gin_tips.
(Description quoted from the official PostgreSQL documentation.)
How to apply a change
Can be set per session with SET, per role/database with ALTER ROLE/DATABASE ... SET, or globally in postgresql.conf.
Inspect the current value and source with SHOW gin_fuzzy_search_limit; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'gin_fuzzy_search_limit';.
Tuning guidance
This sets a session default (locale, formatting, search path or transaction behaviour) rather than a performance knob. Set it per role or database with ALTER ROLE/DATABASE ... SET so the right default follows the right workload, and prefer setting it explicitly in the application for behaviour the query results depend on.