Received: from candle.pha.pa.us (pgman@nav-43.dsl.navpoint.com [162.33.245.46]) by hub.org (8.10.1/8.10.1) with ESMTP id e5OL90178997 for ; Sat, 24 Jun 2000 17:09:00 -0400 (EDT) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id RAA03562; Sat, 24 Jun 2000 17:08:21 -0400 (EDT) From: Bruce Momjian Message-Id: <200006242108.RAA03562@candle.pha.pa.us> Subject: Re: More full text index.. In-Reply-To: <001d01bfde1d$a411a1a0$0300000a@doot.org> "from Mitch Vincent at Jun 24, 2000 04:49:06 pm" To: Mitch Vincent Date: Sat, 24 Jun 2000 17:08:20 -0400 (EDT) CC: pgsql-sql@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200006/221 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@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026