Re: indexing large "text" attributes ... ERROR: maximum size is 8191

Benjamin Arai <me(at)benjaminarai(dot)com> writes:
> The tsearch2 webpage says to do something like

> SELECT intindex, strTopic FROM tblmessages
> WHERE idxfti @@ to_tsquery('default', 'gettysburg &
> address')
> AND strMessage ~* '.*men are created equal.*';
> intindex | strtopic
> ----------+------------------------------
> 6 | Gettysburg address quotation
> (1 row)

Right.

> Which would mean I would have to create index on strMessage. Right?

Wrong. A btree index on strMessage is utterly worthless for checking
that pattern match, and even if it did work, there's no point in using
a second index to check it rather than fetching the heap entry.

regards, tom lane