From: | Oleg Bartunov <obartunov(at)gmail(dot)com> |
---|---|
To: | Howard News <howardnews(at)selestial(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Shrinking TSvectors |
Date: | 2016-04-05 13:44:42 |
Message-ID: | CAF4Au4yJZLWMhg391DcQ79D5RGTReSeFcyubpVfW8nNdBkSeOQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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)
>
> Thanks,
>
> Howard.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Rakesh Kumar | 2016-04-05 14:11:28 | What does Rows Counted mean |
Previous Message | Lars Arvidson | 2016-04-05 12:55:04 | Problem after replication switchover |