SELECT set_smlar_limit(5.0); set_smlar_limit ----------------- 5 (1 row) SET smlar.type='overlap'; DROP INDEX idx_test_text; SELECT smlar('{199,199,199,199,1}', '{199,1}'::text[]); smlar ------- 2 (1 row) SELECT t, smlar(v, '{199,198,197,196,195,194,193,192,191,190}') AS s FROM test_text WHERE v % '{199,198,197,196,195,194,193,192,191,190}' ORDER BY s DESC, t; t | s -----+---- 199 | 10 200 | 10 198 | 9 197 | 8 196 | 7 195 | 6 194 | 5 (7 rows) CREATE INDEX idx_test_text ON test_text USING gin (v _text_sml_ops); SET enable_seqscan = off; SELECT t, smlar(v, '{199,198,197,196,195,194,193,192,191,190}') AS s FROM test_text WHERE v % '{199,198,197,196,195,194,193,192,191,190}' ORDER BY s DESC, t; t | s -----+---- 199 | 10 200 | 10 198 | 9 197 | 8 196 | 7 195 | 6 194 | 5 (7 rows) RESET enable_seqscan;