rum

pig build pkg rum         # 构建 RPM 包

pig repo add pgsql -u          # 添加仓库并更新缓存

CREATE EXTENSION rum;

CREATE INDEX idx ON table_name USING rum (column operator_class);

CREATE INDEX tsts_idx ON tsts USING rum (t rum_tsvector_addon_ops, d)
    WITH (attach = 'd', to = 't');

SELECT t, a <=> to_tsquery('english', 'beautiful | place') AS rank
FROM test_rum
WHERE a @@ to_tsquery('english', 'beautiful | place')
ORDER BY a <=> to_tsquery('english', 'beautiful | place');

SELECT id, d, d <=> '2016-05-16 14:21:25' FROM tsts
WHERE t @@ 'wr&qh'
ORDER BY d <=> '2016-05-16 14:21:25'
LIMIT 5;

SELECT * FROM test_array
WHERE i && '{1}'
ORDER BY i <=> '{1}' ASC;