rum icon indicating copy to clipboard operation
rum copied to clipboard

SQL statement runs infinitely

Open degtyaryov opened this issue 6 years ago • 0 comments

Hello!

Experimented with RUM.

Purely by chance, I created a table:

CREATE TABLE test
(
    tsvector1 tsvector,
    tsvector2 tsvector
);

Insert data into it:

INSERT INTO test(tsvector1, tsvector2)
SELECT to_tsvector('russian'::regconfig, 'тест '||s), to_tsvector('english'::regconfig, 'test '||s)
FROM generate_series(1, 1000000) s;

Created an index:

CREATE INDEX idx_test_rum
ON test
USING rum (tsvector1, tsvector2);

Run the SQL statement:

SELECT  *,
        tsvector1 <=> plainto_tsquery('russian'::regconfig, 'тест') as rank1,
        tsvector2 <=> plainto_tsquery('english'::regconfig, 'test') as rank2
FROM test
WHERE  tsvector1 @@ plainto_tsquery('russian'::regconfig, 'тест')
ORDER BY rank1, rank2
LIMIT 1000;

SQL statement runs infinitely!

Query is not canceled by pg_cancel_backend and disconnect client. Unable to stop server PostgreSQL.

Only kill -SIGKILL.

I check this on PostgreSQL 10 and PostgreSQL 12. RUM latest release 1.3.6 and latest commit e34375a.

degtyaryov avatar Oct 02 '19 12:10 degtyaryov