g
IECIA
(1 row)
`E' here is a polish letter. I have set locale to `pl_PL' before
starting postgres.
Best regards
Artur Rataj
shows:
Index Scan using fti_key on fti
(cost=19249.90 rows=1 width=4)
The original table has about 4.000 rows, and the full text index
table has about 1.000.000 rows.
Why the query that uses the full text index is so slow, in compare to
a sequential scan?
Best regards
Artur Rataj
On Fri, 15 Dec 2000, Artur Rataj wrote:
> Hello,
>
> I have a question about a full text index.
> I have created such index over a text field. I have stored
> substrings of each word in the text field, so that for `example' they
> would be `example', `xample'
