Oleg and friends; Should we use GitHub-issues as forum (one issue per question/thread?), pgsql-general or something else?
Andreas,
we are hardly working on our internal version of rum and will open it after resolving some issues. I think the best place to discuss it is -hackers.
Ah, as someone corrected me, we are working hard !
He he, I figured that was what you meant:-)
Ok, so basically - will RUM-index support the same indexing-properties as GIN (being able to index tsvector, BIGINT-arrays, JSONB etc.) and be able to use index for sorting on ie. timestamp, tsrank or some BIGINT-column?
Like my example, will it be possible to issue a query like this:
SELECT del.id , del.sent FROM delivery del WHERE 1 = 1
AND del.fts_all @@ to_tsquery('simple', 'hi:*') AND del.folder_id = ANY(ARRAY[2,3]::BIGINT[])
ORDER BY del.sent DESC LIMIT 101 OFFSET 0;
and have it use one RUM-index so the whole operation, including sorting, is as efficient as possible?
we have implementation for timestamp. One need to write opclass to deal with arrays, it shouldn't be difficult.