Question about creating tsvector column or not

[rudibroekhuizen]

Hi, I get really great results using a rum index searching our datasets at naturalis.nl, thanks for your great work!

I have question. In this presentation: https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2116/slides/137/pgconf.eu-2018-fts.pdf it states "no need tsvector column". Can you provide an example command to create a rum index without first creating a tsvector column? Thanks!

[obartunov]

On Wed, Oct 30, 2019 at 2:15 PM Rudi Broekhuizen ***@***.***> wrote: Hi, I get really great results using a rum index searching our datasets at naturalis.nl, thanks for your great work! I have question. In this presentation: https://www.postgresql.eu/events/pgconfeu2018/sessions/session/2116/slides/137/pgconf.eu-2018-fts.pdf it states "no need tsvector column". Can you provide an example command to create a rum index without first creating a tsvector column? Thanks!

You mean slide #75 (see attached) ? Index can be created without tsvector column for any kind of indexes, but only RUM index preserves the coordinates to calculate ranks. Example: create index .... using rum (to_tsvector(.....) ....);

…

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#71?email_source=notifications&email_token=ABQURYQDS52FKQDIXJNDROLQRFUE3A5CNFSM4JGXP7P2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HVL5LXA>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABQURYWAQWFKOFUFCZ4F243QRFUE3ANCNFSM4JGXP7PQ> .

-- Postgres Professional: http://www.postgrespro.com The Russian Postgres Company

[rudibroekhuizen]

Ok, thanks for your answer, I will try that!