Re: FTI is really really slow; what am I doing wrong? - Mailing list pgsql-general

"Paul C." <ulive1x@hotmail.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