Received: from cooncatgamma.aretoo.com (unknown [63.94.251.10]) by postgresql.org (Postfix) with ESMTP id 9239847621C for ; Fri, 22 Mar 2002 13:49:46 -0500 (EST) Received: from david ([192.168.100.198]) by cooncatgamma.aretoo.com (8.11.2/8.11.2/SuSE Linux 8.11.1-0.5) with SMTP id g2MInkZ12411 for ; Fri, 22 Mar 2002 13:49:46 -0500 From: "David Siebert" To: Subject: Re: Yet another indexing issue. Date: Fri, 22 Mar 2002 13:49:46 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-reply-to: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Importance: Normal X-Archive-Number: 200203/1149 X-Sequence-Number: 22511 Thank you. I found the error. It was the order of the fields in the index. I do not rember seeing that the order made a difference in the indexing. It is logical now that I think of it. I for the life of me could not find where in PgAdminII I could set the order of the fields in when creating an index so I did it by hand. Thanks again. -----Original Message----- From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org]On Behalf Of Pirtea Calin Sent: Friday, March 22, 2002 9:38 AM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] Yet another indexing issue. > > 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). > I found this in Admin.pdf 3.4.1. Planner and Optimizer Tuning page 37/38 ENABLE_SEQSCAN (boolean) Enables or disables the query planner's use of sequential scan plan types. It's not possible to suppress sequential scans entirely, but turning this variable off discourages the planner from using one if there is any other method available. The default is on. This is mostly useful to debug the query planner. -- Best regards, Aplication Developer Pirtea Calin Iancu S.C. SoftScape S.R.L. pcalin@rdsor.ro ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html