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

it possible to make `similarity` use the index? If 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 Zak

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

ility 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.o

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

't supported then it might be a good idea for a contribution. Best regards On Fri, Jun 3, 2016 at 12:51 PM, Artur Zakirov mailto:a.zaki...@postgrespro.ru>> wrote: Hello. As I know 'lhs % rhs' is equivalent to 'similarity(lhs, rhs) >= show_limit()

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

ly your plan differs from 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

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

ance you do not need threshold. > > Thanks 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] FTS with more than one language in body and with unknown query language?

ictionary. * Any 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] 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 : On 14.07.2016 01:16, Stefan Keller wrote: ... * Should I create a synonym dictionary which contains word translations en-de instead of synonyms

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

'geo', 'walde'); id | body_en | body_de +-+- 1 | forest | (null) (1 row) I 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] Updated RUM-index and support for bigint as part of index

e 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] Updated RUM-index and support for bigint as part of index

'andreas') ORDER BY received <=> '2013-01-01' DESC LIMIT 8; id |received | rank +-+-- 6 | 2015-09-29 00:26:56 | 86488016 3 | 2015-08-18 03:49:02 | 82871342 2 | 2015-08-18 03:07:55 | 8286

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

nto_tsquery() with specified configuration should be faster and plainto_tsquery(regconfig,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] Incorrect information about GIN-index in RUM's docs

mbiguous. GIN supports it, but it requires additional bitmap heap scan and so it slower. I fixed it. Thank you. -- *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://w

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

e2 ON table1.table2_id=table2.id ) subquery WHERE subquery.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

Re: [GENERAL] Install pgAudit extension

USE_PGXS=1 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] Using a german affix file for compound words

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) 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

Re: [GENERAL] commit time in logical decoding

ou in advance, Kind Regards, Weiping -- 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] Shrinking TSvectors

| english_stem postgres=# \dF+ english_cfg Text search configuration "public.english_cfg" Parser: "pg_catalog.default" Token | Dictionaries -+-- asciihword | english_stem asciiword | english_stem hword | englis

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

ttp://www.postgresql.org/docs/devel/static/docguide-toolsets.html Thanks. -- *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 Zaki

Re: [GENERAL] Question about ranking & full text

often the query terms appear in the document, how close 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 a

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.03039

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

or, to_tsquery('hello') query WHERE query @@ vector; s | 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 Post

Re: [GENERAL] Full Text Search combined with Fuzzy

27;, texts) FROM test_trgm WHERE 'hello word' <% texts; texts | word_similarity ---+- blah blah blah hello world blah blah blah |0.818182 blah blah blah hello word blah blah blah

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