- Notifications
You must be signed in to change notification settings - Fork58
Open
Description
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_rumON testUSING rum (tsvector1, tsvector2);Run the SQL statement:
SELECT *, tsvector1 <=> plainto_tsquery('russian'::regconfig, 'тест') as rank1, tsvector2 <=> plainto_tsquery('english'::regconfig, 'test') as rank2FROM testWHERE tsvector1 @@ plainto_tsquery('russian'::regconfig, 'тест')ORDER BY rank1, rank2LIMIT 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 commite34375a.
Metadata
Metadata
Assignees
Labels
No labels