X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 24366474E42 for ; Tue, 25 Feb 2003 08:49:01 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 16398-05 for ; Tue, 25 Feb 2003 08:48:50 -0500 (EST) Received: from wolff.to (wolff.to [66.93.249.74]) by postgresql.org (Postfix) with SMTP id ADDCD475A3F for ; Tue, 25 Feb 2003 08:42:52 -0500 (EST) Received: (qmail 30334 invoked by uid 500); 25 Feb 2003 13:56:29 -0000 Date: Tue, 25 Feb 2003 07:56:29 -0600 From: Bruno Wolff III To: Mark Halliwell Cc: pgsql-performance@postgresql.org Subject: Re: Query not using the index Message-ID: <20030225135629.GA30236@wolff.to> Mail-Followup-To: Mark Halliwell , pgsql-performance@postgresql.org References: <200302251903.40364.mark@transportservices.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200302251903.40364.mark@transportservices.com.au> User-Agent: Mutt/1.3.25i X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/196 X-Sequence-Number: 1252 On Tue, Feb 25, 2003 at 19:03:40 +1100, Mark Halliwell wrote: > > The majority of records (about 6.8 million) have computer = 8 with sequence > starting at 2200000 and incrementing by 1. > There are about 497000 records with computer = 3 with the sequence starting at > 1 and also incrementing by 1. > There are only a few records with other computer numbers. You might get some benefit using a partial index that just covers the rows where computer = 3.