Infinity

(56 rows)

CREATE TABLE tst (i int4, t tsvector);

INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(1,100000) i;

CREATE INDEX tstidx ON tst USING rum (t rum_tsvector_ops);

DELETE FROM tst WHERE i = 1;

VACUUM tst;

INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(10001,11000) i;

DELETE FROM tst WHERE i = 2;

VACUUM tst;

INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(11001,12000) i;

DELETE FROM tst WHERE i = 3;

VACUUM tst;

INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(12001,13000) i;

DELETE FROM tst WHERE i = 4;

VACUUM tst;

INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(13001,14000) i;

DELETE FROM tst WHERE i = 5;

VACUUM tst;

INSERT INTO tst SELECT i%10, to_tsvector('simple', substr(md5(i::text), 1, 1)) FROM generate_series(14001,15000) i;

set enable_bitmapscan=off;

explain (costs off)

SELECT a <=> to_tsquery('pg_catalog.english', 'w:*'), *

ORDER BY a <=> to_tsquery('pg_catalog.english', 'w:*');

ERROR: Compare with prefix expressions isn't supported

DROP TABLE test_rum CASCADE;

DROP TABLE tst CASCADE;

SELECT a<=> to_tsquery('pg_catalog.english','ever|wrote')FROM test_rumORDER BY a<=> to_tsquery('pg_catalog.english','ever|wrote');

CREATETABLEtst (i int4, t tsvector);

INSERT INTO tstSELECT i%10, to_tsvector('simple', substr(md5(i::text),1,1))FROM generate_series(1,100000) i;

CREATEINDEXtstidxON tst USING rum (t rum_tsvector_ops);

DELETEFROM tstWHERE i=1;

VACUUM tst;

INSERT INTO tstSELECT i%10, to_tsvector('simple', substr(md5(i::text),1,1))FROM generate_series(10001,11000) i;

DELETEFROM tstWHERE i=2;

VACUUM tst;

INSERT INTO tstSELECT i%10, to_tsvector('simple', substr(md5(i::text),1,1))FROM generate_series(11001,12000) i;

DELETEFROM tstWHERE i=3;

VACUUM tst;

INSERT INTO tstSELECT i%10, to_tsvector('simple', substr(md5(i::text),1,1))FROM generate_series(12001,13000) i;

DELETEFROM tstWHERE i=4;

VACUUM tst;

INSERT INTO tstSELECT i%10, to_tsvector('simple', substr(md5(i::text),1,1))FROM generate_series(13001,14000) i;

DELETEFROM tstWHERE i=5;

VACUUM tst;

INSERT INTO tstSELECT i%10, to_tsvector('simple', substr(md5(i::text),1,1))FROM generate_series(14001,15000) i;

set enable_bitmapscan=off;

explain (costs off)

SELECT a<=> to_tsquery('pg_catalog.english','w:*'),*

ORDER BY a<=> to_tsquery('pg_catalog.english','w:*');

DROPTABLE test_rum CASCADE;

DROPTABLE tst CASCADE;