Re: Full Text Index disk space requirements

Hi,

if memory serves me right, the space requirements for this would be
something like:

42 (per tuple overhead)
4 (size of OID?)
16 (substitute with the maximum length of any 'string' in your
fulltext.sorted)
+ -------------
62
20,000,000 (substitute with number of lines in fulltext.sorted,
i.e. 'wc -l fulltext.sorted')
*---------------------------
1,240,000,000

or about 1.2G?

or
On 11/26/2002 01:36:59 PM typea wrote:
> Wouldn't using f1.string = 'perth' be faster than f1.string ~ '^perth'
and
> equally useful? Or is ~ with ^ somehow actually faster than the
seemingly
> simple = comparison?

f1.string = 'perth' would only match 'perth', while f1.string ~ '^perth'
would also match 'perthinent' (yes, I know this word does not exist).

Maarten

ps. are you trying to use the stuf from the 'fulltextindex' directory in
contrib/? I originally wrote this as an experiment, and it actually turned
out not to be fast enough for my purpose. I've never done anything with
full text indexing again, but I believe that currently there are better
solutions based on PostgreSQL (i.e. OpenFTI?)

-------------------------------------------------------------- --
Visit our Internet site at http://www.reuters.com

Get closer to the financial markets with Reuters Messaging - for more
information and to register, visit http://www.reuters.com/messaging

Any views expressed in this message are those of the individual
sender, except where the sender specifically states them to be
the views of Reuters Ltd.