Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Tom LaneDate: 2000-06-25 02:19:25
Subject: Re: More full text index..
Previous:From: Mitch VincentDate: 2000-06-24 20:49:06
Subject: Re: More full text index..

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group