X-Original-To: pgsql-performance@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 134D84797C1 for ; Fri, 31 Jan 2003 20:49:36 -0500 (EST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by postgresql.org (Postfix) with ESMTP id 5F37747D77C for ; Fri, 31 Jan 2003 18:31:02 -0500 (EST) Received: from andrew by mail.libertyrms.com with local (Exim 3.22 #3 (Debian)) id 18ekci-0007f3-00 for ; Fri, 31 Jan 2003 18:31:04 -0500 Date: Fri, 31 Jan 2003 18:31:04 -0500 From: Andrew Sullivan To: "'pgsql-performance@postgresql.org'" Subject: Re: not using index for select min(...) Message-ID: <20030131183104.L24535@mail.libertyrms.com> Mail-Followup-To: Andrew Sullivan , "'pgsql-performance@postgresql.org'" References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from don@sandvine.com on Fri, Jan 31, 2003 at 04:12:38PM -0500 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/407 X-Sequence-Number: 1054 On Fri, Jan 31, 2003 at 04:12:38PM -0500, Don Bowman wrote: > Why wouldn't I be doing an index scan on this table? Because you're using the aggregate function min(). See A -- ---- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110