Re: tsvector limitations

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tim" <elatllat(at)gmail(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: tsvector limitations
Date: 2011-06-14 14:18:20
Message-ID: 4DF7275C020000250003E59F@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Tim <elatllat(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tim 2011-06-14 15:08:14 Re: tsvector limitations
Previous Message Tim 2011-06-14 01:58:54 Re: tsvector limitations