Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 9220C47546E for ; Mon, 1 Apr 2002 20:43:47 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g321hiF19566; Mon, 1 Apr 2002 20:43:44 -0500 (EST) To: dan@langille.org Cc: pgsql-sql@postgresql.org Subject: Re: selecting records from a date range In-reply-to: <20020402003614.C631D3F29@bast.unixathome.org> References: <20020402003614.C631D3F29@bast.unixathome.org> Comments: In-reply-to "Dan Langille" message dated "Mon, 01 Apr 2002 19:36:17 -0500" Date: Mon, 01 Apr 2002 20:43:44 -0500 Message-ID: <19563.1017711824@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200204/8 X-Sequence-Number: 7273 "Dan Langille" writes: > I'm having fun with this one. It was nice and fast before the vacuum, but > very > slow afterwards. The idea is to get all the records for a given day. [ scratches head... ] I tried to reproduce this, but for me it still seems to prefer nestloop. Have you been playing any games with the planner cost parameters? What does pg_stats show for these tables? regards, tom lane