Re: FTI is really really slow; what am I doing wrong?

"Paul C." <ulive1x(at)hotmail(dot)com> writes:
> Indeed, the cost to look up a single string in the st_fti
> table is way high:
> select * from st_fti where string ~ '^kepler';
> costs 36703.40, AND its doing a Seq Scan on st_fti, even though an index
> exists.

Have you done a VACUUM ANALYZE on st_fti? Are you running the database
in plain C locale?

regards, tom lane