rum

rum copied to clipboard

ERROR: array must not contain nulls

2

Hello! RUM extension works as expected until today. All queries stop working because of NULL in data and in JOIN clause (req.allowed_in_country set to NULL in one row). `ERROR: array...

ArturFormella

installcheck many failures when pg server guc "exit_on_error=true"

2

installcheck fails with many errors for a pg server with the guc "exit_on_error=true". perhaps the installcheck scripts could set exit_on_error=true? i tested under fedora 4.19.10-300.fc29.x86_64.

jmscott

indexing inherited tables

14

Hi! We urgently need to index all inherited tables by parent - tell me what to do for this?

IvanKonevJr

Hi. Having this index: ``` create index origo_email_delivery_fts_all_folder_idx ON origo_email_delivery using gin (fts_all, folder_id) ``` And this query: ```sql EXPLAIN ANALYZE SELECT del.entity_id, del.received_timestamp, del.received_timestamp '3000-01-01' :: TIMESTAMP, del.folder_id FROM...

andreak

Hi: when I read the rum source, I find that RUM add a left link in RumPageOpaqueData struct, it different from gin. why add this？ because of ranking from index??...

joseph-zh

Support indexing tsquery phrases

4

Currently indexing with rum fails, if the tsquery column or expression contains phrases: > ERROR: Indexing of phrase tsqueries isn't supported yet It would be very useful if this feature...

felixbuenemann

about genericxlog in rum

2

Hello: I have a question to ask. RUM index is a extension for PostgreSQL，so it only can use Generic Xlog to write wal. I want to put RUM into PG,As...

joseph-zh

From #15. Estimated row count is not good: ```sql explain (analyze) select * from rum where tsvector @@ 'cow'::tsquery order by id (10^6)::int limit 10; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=12.00..13.43...

za-arthur

From #15. The DESC query slower: ```sql explain analyze select * from rum where tsvector @@ plainto_tsquery('simple', 'cow') order by id 1000000 limit 10; QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------ Limit (cost=3.00..3.53 rows=10...

za-arthur

fast update

5

Hello Recently,I use rum in my project. I want to use fast update like gin index. I check the previous Issues and find that the fast update is exist before....

joseph-zh