Re: More full text index..

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Mitch Vincent <mitch(at)venux(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: More full text index..
Date: 2000-06-24 21:08:20
Message-ID: 200006242108.RAA03562@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2000-06-25 02:19:25 Re: More full text index..
Previous Message Mitch Vincent 2000-06-24 20:49:06 Re: More full text index..