Re: Searching for pgweb

On Wed, Mar 29, 2017 at 3:55 PM, Oleg Bartunov <obartunov(at)gmail(dot)com> wrote:

>
>
> On 29 Mar 2017 09:49, "Magnus Hagander" <magnus(at)hagander(dot)net> wrote:
>
>
>
> On Fri, Mar 24, 2017 at 8:56 AM, Oleg Bartunov <obartunov(at)gmail(dot)com>
> wrote:
>
>>
>>
>> On Wed, Mar 22, 2017 at 7:51 PM, Magnus Hagander <magnus(at)hagander(dot)net>
>> wrote:
>>
>>> Right now our main website search uses plainto_tsquery() to generate the
>>> searches.
>>>
>>> Should we consider switching that to phraseto_tsquery() now that we have
>>> phrase searching?
>>>
>>
>> +1
>>
>> Also, I suggest to use new parser, which better works _ and -, for
>> example:
>>
>> 1.
>> select ts_parse('tsparser', 'btree_gin');
>> ts_parse
>> ----------------
>> (16,btree_gin)
>> (11,btree)
>> (12,_)
>> (11,gin)
>> (4 rows)
>>
>> select ts_parse('default', 'btree_gin');
>> ts_parse
>> -----------
>> (1,btree)
>> (12,_)
>> (1,gin)
>> (3 rows)
>>
>> Default parser produces too much noise, just check the difference:
>>
>> https://postgrespro.ru/search/?area=version&q=btree_gin&prod
>> uct=postgresql&version=9.6
>>
>> https://www.postgresql.org/search/?u=%2Fdocs%2F9.6%2F&q=btree_gin
>>
>>
>> 2.
>> select ts_parse('tsparser', 'utc-5');
>> ts_parse
>> ------------
>> (15,utc-5)
>> (11,utc)
>> (12,-)
>> (9,5)
>> (4 rows)
>>
>> select ts_parse('default', 'utc-5');
>> ts_parse
>> ----------
>> (1,utc)
>> (21,-5)
>> (2 rows)
>>
>> again, compare
>>
>> https://postgrespro.ru/search/?area=version&q=utc-5&product=
>> postgresql&version=9.6
>>
>> https://www.postgresql.org/search/?u=%2Fdocs%2F9.6%2F&q=utc-5
>>
>>
>> We have also better parsing of email, but I'm not sure we need it on
>> postgres site.
>>
>> We'll publish soon on github, let me know if you know it.
>>
>>
> That sounds interesting. Two questions:
>
> 1. Do you have plans for contributing this one for upstream postgres, or
> is it intended to be run separately?
>
>
> We would love to do this, but currently it's there
> https://github.com/postgrespro/pg_tsparser
>

Right, found that one. But if your long term plan is to contribute it
upstream, that makes it easier to rely on :)

> 2. Would it still make sense to do phrase searching? Sounds like it would?
>
>
> Yes, it would.
>
>

Cool, thanks.

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/