Re: [SQL] More full text index..

[Bruce Momjian]

Check this out..
> 
> databasename=# explain delete from resumes_fti where id=86370016;
> NOTICE:  QUERY PLAN:
> 
> Seq Scan on resumes_fti  (cost=0.00..394577.18 rows=1956 width=6)
> 
> EXPLAIN
> 
> Ouch :-)

Bingo.  Is there an index on id?

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026