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

2001-08-22 Thread Paul C.
Meant to send this to the whole list... I had vaccum'ed it, but not 'vacuum analyze' -ed it. That did the trick. Cost down to 12.09 from 80628.92. Thank you! >From: "Mitch Vincent" <[EMAIL PROTECTED]> >To: "Paul C." <[EMAIL PROTECTED]>

[GENERAL] FTI is really really slow; what am I doing wrong?

2001-08-22 Thread Paul C.
Scan on st_fti, even though an index exists. What am I doing wrong? Is it the sheer size of the st_fti table that is causing problems? Any help would be greatly appreciated. Thanks, Paul C. FTI search NOTICE: QUERY PLAN: Merge Join (cost=80046.91..80628.92 rows=110 width=28) -> Sort