{"repo":"postgrespro/rum","free":true,"listed":false,"github":"https://github.com/postgrespro/rum","clone":"git clone https://github.com/postgrespro/rum.git","description":"RUM access method - inverted index with additional information in posting lists","language":"C","stars":840,"topics":["postgresql","index","access-method","fulltext-search"],"license":null,"category":"databases-storage","readme_excerpt":"RUM - RUM access method Introduction The rum module provides access method to work with the RUM indexes. It is based on the GIN access method code. GIN index allows you to perform fast full-text search using tsvector and tsquery types. However, full-text search with GIN index has some performance issues because positional and other additional information is not stored. RUM solves these issues by storing additional information in a posting tree. As compared to GIN , RUM index has the following benefits: - Faster ranking. Ranking requires positional information. And after the index scan we do not need an additional heap scan to retrieve lexeme positions because RUM index stores them. - Faster phrase search. This improvement is related to the previous one as phrase search also needs positional information. - Faster ordering by timestamp. RUM index stores additional information together with lexemes, so it is not necessary to perform a heap scan. - A possibility to perform depth-first search and therefore return first results immediately. You can get an idea of RUM with the following diagram: The drawback of RUM is that it has slower build and insert time as compared to GIN This is because we need to store additional information besides keys and because because RUM stores additional information together with keys and uses generic WAL records. License This module is available under the license similar to PostgreSQL. Installation Before building and installing rum , you should ensu","default_branch":null,"files":null,"tree":[],"storefront":"/r/postgrespro","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/postgrespro/rum/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}