rum
rum copied to clipboard
RUM access method - inverted index with additional information in posting lists
Can this be installed on Mac OSX? I tried the github installation and it appears I'm missing some c libraries. Has anyone had any luck installing on Mac? I am...
Below are two cases showing wrong results returned from RUM index with `order_by_attach=TRUE`. In both test cases, if `order_by_attach=FALSE`, correct results will be returned. Tested with PostgreSQL 12.2 & newest...
Hi, Is there plan for rum index to support covering indexes [1]? Right now, when trying to create a rum index with INCLUDE, it will show: > ERROR: access method...
``` git apply PostgresNode.patch.txt echo 'exec valgrind postgres "$@"' > /tmp/pgvalgrind && chmod +x /tmp/pgvalgrind PGLAUNCHER=/tmp/pgvalgrind make check -C contrib/rum ``` in command `CREATE INDEX rumidx ON tst USING rum...
I was wondering how to set up ad hoc search using RUM indexes. For example, I have a table with three columns. I would like to search combinations of the...
I'm just starting to get into Postgres development. I'm trying to understand index structures and how to extend them. I noticed that you folks are also the ones that maintain...
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,...
hi i am thinking of using rum instead of gin but was wondering if it has the same 1Mb limitation as when i try to index my column with gin...
Suppose you have this table `> CREATE TABLE news_items (id int, object_data JSONB, weighted_tsv tsvector, time_created_from_server bigint);` Also, supposing the object_data jsonb has the following fields: title, article, author and...
Suppose you have this table `CREATE TABLE articles (id int, object_data JSONB);` If object_data has two fields (article & timeCreatedAsFromServer) The following returns the error _ERROR: attribute "((object_data -> 'timeCreatedAsFromServer')::bigint)"...