Introduction

License

Installation

$ git clone https://github.com/postgrespro/rum$ cd rum$ make USE_PGXS=1$ sudo make USE_PGXS=1 install$ make USE_PGXS=1 installcheck$ psql DB -c "CREATE EXTENSION rum;"

New access method and operator class

Examples

CREATETABLEtest_rum(ttext, a tsvector);CREATETRIGGERtsvectorupdateBEFOREUPDATEOR INSERTON test_rumFOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger('a','pg_catalog.english','t');INSERT INTO test_rum(t)VALUES ('The situation is most beautiful');INSERT INTO test_rum(t)VALUES ('It is a beautiful');INSERT INTO test_rum(t)VALUES ('It looks like a beautiful place');

CREATE EXTENSION rum;

CREATEINDEXrumidxON test_rum USING rum (a rum_tsvector_ops);

=# SELECT t, a <-> to_tsquery('english', 'beautiful | place') AS rankFROM test_rumWHERE a @@ to_tsquery('english','beautiful | place')ORDER BY a<-> to_tsquery('english','beautiful | place');                t                |   rank---------------------------------+----------- The situation is most beautiful |0.0303964 It is a beautiful               |0.0303964 It lookslike a beautiful place |0.0607927(3 rows)=# SELECT t, a <-> to_tsquery('english', 'place | situation') AS rankFROM test_rumWHERE a @@ to_tsquery('english','place | situation')ORDER BY a<-> to_tsquery('english','place | situation');                t                |   rank---------------------------------+----------- The situation is most beautiful |0.0303964 It lookslike a beautiful place |0.0303964(2 rows)

Authors