Kouhei Sutou
null+****@clear*****
Mon May 29 16:44:50 JST 2017
Kouhei Sutou 2017-05-29 16:44:50 +0900 (Mon, 29 May 2017) New Revision: fc75dc6b4b22162984b3d02c990d2dd0adade633 https://github.com/pgroonga/pgroonga.github.io/commit/fc75dc6b4b22162984b3d02c990d2dd0adade633 Message: Document pgoroonga.match_escalation_threshold Added files: reference/parameters/match-escalation-threshold.md Added: reference/parameters/match-escalation-threshold.md (+42 -0) 100644 =================================================================== --- /dev/null +++ reference/parameters/match-escalation-threshold.md 2017-05-29 16:44:50 +0900 (a35c68f) @@ -0,0 +1,42 @@ +--- +title: "pgroonga.match_escalation_threshold parameter" +upper_level: ../ +--- + +# `pgroonga.match_escalation_threshold` parameter + +## Summary + +`pgroonga.match_escalation_threshold` parameter controls when match escalation is occurred. + +Match escalation is auto loose search. If the number of matched records is equal or less than the threshold specified by `pgroonga.match_escalation_threshold` parameter, loose search is done automatically. It's match escalation. + +The default threshold is `0`. It means that no records are matched, loose search is done automatically. + +You can disable match escalation by specifying `-1`. + +Normally, you don't need to change this parameter. Auto loose search is useful for users. + +## Syntax + +In SQL: + +```sql +SET pgroonga.match_escalation_threshold = threshold; +``` + +In `postgresql.conf`: + +```text +pgroonga.match_escalation_threshold = threshold +``` + +`threshold` is a number value. + +## Usage + +Here is an example to disable match escalation: + +```sql +SET pgroonga.match_escalation_threshold = -1; +``` -------------- next part -------------- HTML����������������������������...Download