Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id 3FC0F475988 for ; Tue, 19 Mar 2002 19:01:29 -0500 (EST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 3C3DAD5F7; Tue, 19 Mar 2002 16:01:28 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 31E365BFC; Tue, 19 Mar 2002 16:01:28 -0800 (PST) Date: Tue, 19 Mar 2002 16:01:28 -0800 (PST) From: Stephan Szabo To: David Siebert Cc: Subject: Re: Yet another indexing issue. In-Reply-To: Message-ID: <20020319155803.G37657-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200203/975 X-Sequence-Number: 22344 On Tue, 19 Mar 2002, David Siebert wrote: > Here is the explain output > > Sort (cost=293.24..293.24 rows=1 width=128) > -> Seq Scan on phonecalls (cost=0.00..293.23 rows=1 width=128) > > Here is the Table > CREATE TABLE "phonecalls" ( > "irecnum" int4 DEFAULT nextval('"phonecalls_irecnum_seq"'::text) NOT NULL, > "scaller" varchar(80), > "sphone" varchar(40), > "sphone2" varchar(40), > "squedby" varchar(40), > "sfor" varchar(40), > "dplaceddate" timestamp, > "dtakendate" timestamp, > "dresdate" timestamp, > "ipri" int4, > "istatus" int4, > "iresolution" int4, > "ireques" int4, > "snotes" varchar(3999), > "stakenby" varchar(40), > CONSTRAINT "phonecalls_irecnum_key" UNIQUE ("irecnum") > ); > > Where would one find set enable_seqscan=off; in the docs? To be honest I'm not sure where it's mentioned. It's a big tool that lets you make some gross changes to the optimizer's planning (sets the cost of sequence scan very very high). Does doing it before the explain change the output? Also, does making an index on phonecalls(istatus, sfor) [rather than sfor,istatus] change the choice?