PostgreSQL version:

gin_fuzzy_search_limit

Soft upper limit of the size of the set returned by GIN index scans. For more information see gin-tips.

Recommendations

If you're going to use GIN queries in a web application, it's generally useful to set a limit on how many rows can be returned from the index just for response times. However, the maximum number needs to depend on your application; what do users see as an acceptable expression of "many"?

Comments

Type: integer
Default: 0
Min: 0
Max: 2147483647
Context: user
Restart: false