Re: [GENERAL] Full Text Search combined with Fuzzy

, there is no plans in the near future to add similarity full text search. 1. https://www.postgresql.org/docs/current/static/textsearch-dictionaries.html -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] Full Text Search combined with Fuzzy

| word_similarity ---+- blah blah blah hello world blah blah blah |0.818182 blah blah blah hello word blah blah blah | 1 (2 rows) 1. https://www.postgresql.org/docs/9.6/static/pgtrgm.html -- Artur Zakirov P

Re: [GENERAL] Use full text to rank results higher if they are "closer hit"

| rank -+--- hello | 0.0607927 hello world | 0.0303964 (2 rows) And read about **normalization** in [1] https://www.postgresql.org/docs/current/static/textsearch-controls.html -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company

Re: [GENERAL] Use full text to rank results higher if they are "closer hit"

On 14.02.2017 18:57, Artur Zakirov wrote: Hello, try the query: SELECT s, ts_rank(vector, query) AS rank FROM t, to_tsvector(s) vector, to_tsquery('hello') query WHERE query @@ vector; s | rank -+--- hello | 0.0607927 hello world | 0.0303964 (2 rows

Re: [GENERAL] Install pgAudit extension

PG_CONFIG=/pg_config install -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Full text search tsv column aproach vs concat confusion

query.document @@ to_tsquery(unaccent(?)); And specifying a text search configuration makes queries a little bit faster: ... to_tsvector('english', coalesce(table1.col1,'')) ... -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general

Re: [GENERAL] Incorrect information about GIN-index in RUM's docs

sena.com> <https://www.visena.com> -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] FTS query, statistics and planner estimations…

,test) is immutable function. -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Updated RUM-index and support for bigint as part of index

-18 03:07:55 | 82868875 1 | 2015-08-17 23:53:26 | 82857206 8 | 2015-05-09 08:39:14.128 | 74162354.128 5 | 2012-11-20 15:41:04.936 | 3572335.064 7 | 2012-11-21 14:16:26.448 | 3491013.552 4 | 2012-12-03 14:14:05.488 | 2454354.512 (8 rows) I hope this is what you want. -- Artur Zaki

Re: [GENERAL] Updated RUM-index and support for bigint as part of index

se ONE index. > > Will this be supported? > We have a plan to use generic types to able to include bigint, timestamp and other types as part of index. But I cant tell date of it. -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company

Re: [GENERAL] FTS with more than one language in body and with unknown query language?

will be glad for your comments. -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] FTS with more than one language in body and with unknown query language?

Hello, Stefan! On 15.07.2016 01:54, Stefan Keller wrote: приве́т! Artur Thanks for your explanations. 2016-07-14 17:20 GMT+02:00 Artur Zakirov <a.zaki...@postgrespro.ru>: On 14.07.2016 01:16, Stefan Keller wrote: ... * Should I create a synonym dictionary which contains word transl

Re: [GENERAL] FTS with more than one language in body and with unknown query language?

hints to related work where FTS has been used in a multilingual context? :Stefan -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] [pg_trgm] Making similarity(?, ?) < ? use an index

for help. > -- > Greg Navis > I help tech companies to scale Heroku-hosted Rails apps. > Free, biweekly scalability newsletter for SaaS CEOs > <http://www.gregnavis.com/newsletter/> > > -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company

Re: [GENERAL] [pg_trgm] Making similarity(?, ?) < ? use an index

Tom's proposal. And I am afraid that you will do a waste work. -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [GENERAL] [pg_trgm] Making similarity(?, ?) < ? use an index

ution. Best regards On Fri, Jun 3, 2016 at 12:51 PM, Artur Zakirov <a.zaki...@postgrespro.ru <mailto:a.zaki...@postgrespro.ru>> wrote: Hello. As I know 'lhs % rhs' is equivalent to 'similarity(lhs, rhs) >= show_limit()'. And so your query should looks li

Re: [GENERAL] [pg_trgm] Per-query set_limit()

newsletter for SaaS CEOs <http://www.gregnavis.com/newsletter/> -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma

Re: [GENERAL] [pg_trgm] Making similarity(?, ?) < ? use an index

not, is there a way to speed up the query above? Best regards -- Greg Navis I help tech companies to scale Heroku-hosted Rails apps. Free, biweekly scalability newsletter for SaaS CEOs <http://www.gregnavis.com/newsletter/> -- Artur Zakirov Postgres Professional: http://www.postgrespro.com

Re: [GENERAL] Question about ranking & full text

together the terms are in the document, and how important is the part of the document where they occur. In the third example found terms are empty. And the function can't do calculates with empty terms. It sees that the terms are empty and returns 0.0. -- Artur Zakirov Postgres Profession

Re: [GENERAL] How to build docs from master?

*Andreas Joseph Krogh* CTO / Partner - Visena AS Mobile: +47 909 56 963 andr...@visena.com <mailto:andr...@visena.com> www.visena.com <https://www.visena.com> <https://www.visena.com> -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company

Re: [GENERAL] Shrinking TSvectors

h_stem asciiword | english_stem hword | english_stem hword_asciipart | english_stem hword_part | english_stem word| english_stem -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pg

Re: [GENERAL] commit time in logical decoding

eiping -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Using a german affix file for compound words

Did you try a dictionary from http://extensions.openoffice.org/en/project/german-de-de-frami-dictionaries ? You need extract from a downloaded archive de_DE_frami.aff and de_DE_frami.dic files, rename them and convert them to UTF-8. Am 2016-01-28 um 17:34 schrieb Artur Zakirov: On 28.01.2016

Re: [GENERAL] Using a german affix file for compound words

german ); DROP TEXT SEARCH DICTIONARY -> select ts_lexize('german_ispell', 'test'); ts_lexize --- {test} (1 row) -- Artur Zakirov Postgres Professional: http://www.postgrespro.com Russian Postgres Company -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T