From: | Alexander Shereshevsky <shereshevsky(at)gmail(dot)com> |
---|---|
To: | Howard News <howardnews(at)selestial(dot)com> |
Cc: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Shrinking TSvectors |
Date: | 2016-04-05 14:42:15 |
Message-ID: | CAJMMYvr=gg=-P9=bMEiqVOta97M_e4PH4cP4Hh6TeiOJUim3wQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, Apr 5, 2016 at 5:37 PM, Howard News <howardnews(at)selestial(dot)com>
wrote:
>
>
> On 05/04/2016 14:44, Oleg Bartunov wrote:
>
>
>
> On Tue, Apr 5, 2016 at 2:37 PM, Howard News <howardnews(at)selestial(dot)com>
> wrote:
>
>> Hi,
>>
>> does anyone have any pointers for shrinking tsvectors
>>
>> I have looked at the contents of some of these fields and they contain
>> many details that are not needed. For example...
>>
>> "'+1':935,942 '-0500':72 '-0578':932 '-0667':938 '-266':937 '-873':944
>> '-9972':945 '/partners/application.html':222
>> '/partners/program/program-agreement.pdf':271
>> '/partners/reseller.html':181,1073 '01756':50,1083 '07767':54,1087
>> '1':753,771 '12':366 '14':66 (...)"
>>
>
> I am not interested in keeping the numbers or urls in the indexes.
>>
>
>
> select strip ('asd:23');
> strip
> -------
> 'asd'
> (1 row)
>
>
>
> Hi Oleg,
>
> Is this function documented anywhere?
>
> Howard.
>
http://www.postgresql.org/docs/9.4/static/textsearch-features.html#TEXTSEARCH-MANIPULATE-TSVECTOR
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2016-04-05 14:45:53 | Re: Shrinking TSvectors |
Previous Message | Howard News | 2016-04-05 14:37:32 | Re: Shrinking TSvectors |