Re: tsvector limitations - Mailing list pgsql-admin

From Greg Williamson
Subject Re: tsvector limitations
Date
Msg-id 453674.41390.qm@web46113.mail.sp1.yahoo.com
Whole thread Raw
In response to Re: tsvector limitations  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: tsvector limitations  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-admin
Kevin Grittner wrote:



> Tim <elatllat@gmail.com> wrote:
>
<...>
> Your test (whatever data it is that you used) don't seem typical of
> English text.  The entire PostgreSQL documentation in HTML form,
> when all the html files are concatenated is 11424165 bytes (11MB),
> and the tsvector of that is 364410 (356KB).  I don't suppose you
> know of some publicly available file on the web that I could use to
> reproduce your problem?

Try trolling texts at the Internet Archive (archive.org) -- lots of stuff that
has been rendered into ASCII ... Government documents and the like from all
periods; novels and the like that are no longer under copyright, so lots of long
classics.

<http://www.archive.org/stream/ataleoftwocities00098gut/old/2city12p_djvu.txt>
for example ... 765K

HTH,

Greg Williamson

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


pgsql-admin by date:

Previous
From: Tim
Date:
Subject: Re: tsvector limitations
Next
From: sundaram
Date:
Subject: Re: psql shell return codes - checking if database exists