Re: tsvector limitations - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: tsvector limitations
Date
Msg-id 4DF7275C020000250003E59F@gw.wicourts.gov
Whole thread Raw
In response to tsvector limitations  (Tim <elatllat@gmail.com>)
Responses Re: tsvector limitations  (Tim <elatllat@gmail.com>)
List pgsql-admin
Tim <elatllat@gmail.com> wrote:

> How many bytes of a tsvector would a 32MB ascii english unique
> word list make?
> How many bytes of a tsvector would something like "The Lord of the
> Rings.txt" make?

It would appear that nobody has run into this as a limit, nor done
those specific tests.  Storing a series of novels as a single value
in a database seems to be bad design, of course, which might explain
the lack of research.

If you get some numbers through testing, please post them for future
reference.

-Kevin

pgsql-admin by date:

Previous
From: Tim
Date:
Subject: Re: tsvector limitations
Next
From: Tim
Date:
Subject: Re: tsvector limitations