rum
rum copied to clipboard
postgrespro
RUM access method - inverted index with additional information in posting lists
Hi. As Teodor commented on #15 PG will use bitmap scan when having queries like this: ```sql EXPLAIN ANALYZE SELECT del.entity_id, del.received_timestamp, del.received_timestamp '3000-01-01' :: TIMESTAMP, del.folder_id FROM origo_email_delivery del...
I updated [smlar](https://github.com/poppingtonic/smlar) for postgresql 9.6, and this project seems very interesting given smlar's limitations: + sometimes, the `smlar(textarray,textarray)` function in `tfidf` mode will return multiple results with the exact...
I have a database: 220K documents. (31% 9 words or less) Unique words: P30 9 Median 57 P90 656 p99 1837 p99.9 2928 max 6398 ~130K null records (so ~350...
New problem... Trying to create the rum index: `create index some_index on some_table using rum (some_column rum_tsvector_ops);` Here is the text of the error: ``` SQL Error [54000]: ERROR: index...
I see that 210abdd6432d restored compatibility with PG15, could we have a new release tagged with that so I can update the Debian package?
I have read that rum can help with my problem but I can't actually see how. I'm trying to create a `jsonb_path_ops` GIN index on a JSONB field and be...
The query `(A || B) C` does not give any results, though it should be equivalent to `(A C) || (B C)`, which does. The built in GIN index can...
Use postgres REL_12_STABLE branch postgres=# CREATE TABLE tsts (id int, t tsvector, d timestamp); CREATE TABLE postgres=# \copy tsts from '/rum/data/tsts.data' COPY 508 postgres=# CREATE INDEX tsts_idx ON tsts USING...
just a heads up. compile under mac venture clang gives this warning: src/rumdatapage.c:1063:8: warning: variable 'totalCount' set but not used [-Wunused-but-set-variable] int totalCount = 0; the warning appears to be...
Metadata
Owner
Metadata
RUM access method - inverted index with additional information in posting lists