Re: phraseto_tsquery design

2018-06-21 Thread Arthur Zakirov
Hello, On Thu, Jun 21, 2018 at 11:02:32AM -0400, Sagiv Some wrote: > 2. However, it seems impossible to bypass the performance problem of phrase > searching. I conduct quite a bit of phrase searching, and although > postgres' "phraseto_tsquery" performs great on phrases with uncommon words, > it s

phraseto_tsquery design

2018-06-21 Thread Sagiv Some
I recently migrated over from SQL Server to Postgres (through Amazon Aurora) for the cost. I have been working with the full-text search functions for quite some time, but have encountered a few major roadblocks in my quest to use postgres full-text search functionality to its fullest. I am using