X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5045647580B for ; Sat, 8 Feb 2003 21:08:00 -0500 (EST) Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56]) by postgresql.org (Postfix) with ESMTP id 0E28E474E5C for ; Sat, 8 Feb 2003 21:07:58 -0500 (EST) Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian)) id 18hgzu-0008FL-00; Sat, 08 Feb 2003 19:15:10 -0700 Date: Sat, 8 Feb 2003 19:15:10 -0700 From: Roberto Mello To: John Cavacas Cc: pgsql-sql@postgresql.org Subject: Re: query help/sugestions Message-ID: <20030209021510.GB31606@cc.usu.edu> References: <001501c2cf35$f7584a10$6401a8c0@spook> <20030208063539.GA20208@cc.usu.edu> <002a01c2cf44$71948600$6401a8c0@spook> <20030208163855.GD25254@cc.usu.edu> <001f01c2cf97$5e774000$6401a8c0@spook> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline In-Reply-To: <001f01c2cf97$5e774000$6401a8c0@spook> User-Agent: Mutt/1.4i X-message-flag: Please consider using an e-mail program other than Outlook. It's insecure. X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/174 X-Sequence-Number: 11572 On Sat, Feb 08, 2003 at 12:27:34PM -0500, John Cavacas wrote: > > I just started using PostgreSQL recently, and as such I am not sure how > to properlly evaluate the results of EXPLAIN on that query. I started > looking at the documentation last night regarding EXPLAIN but I haven't > gotten my head around it. Any sugestions in that area? Do you have any specific questions? In general you're trying to get rid of sequential scans (Seq Scan). -Roberto -- +----| Roberto Mello - http://www.brasileiro.net/ |------+ + Computer Science Graduate Student, Utah State University + + USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ + File not found. Try again? Try again? Ah, come'on, pleeeeeease!