Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 5105E9FB3E2 for ; Thu, 4 Oct 2007 18:01:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 70650-09 for ; Thu, 4 Oct 2007 18:01:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from pih-relay06.plus.net (pih-relay06.plus.net [212.159.14.133]) by postgresql.org (Postfix) with ESMTP id 03F959FB361 for ; Thu, 4 Oct 2007 18:01:50 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by pih-relay06.plus.net with esmtp (Exim) id 1IdXpK-0001Dy-5c; Thu, 04 Oct 2007 22:01:46 +0100 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id B4DBC27406C; Thu, 4 Oct 2007 22:01:45 +0100 (BST) Message-ID: <470554B9.6070506@archonet.com> Date: Thu, 04 Oct 2007 22:01:45 +0100 From: Richard Huxton User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Scott Marlowe CC: Ben , Tom Lane , pgsql-performance@postgresql.org Subject: Re: quickly getting the top N rows References: <20071004141411.9509fe66.wmoran@collaborativefusion.com> <3785.1191523930@sss.pgh.pa.us> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/48 X-Sequence-Number: 27070 Scott Marlowe wrote: > On 10/4/07, Ben wrote: >> On Thu, 4 Oct 2007, Tom Lane wrote: >> >>> You're being about as clear as mud here, except that you obviously lied >>> about what you were doing in your first message. If you have a planner >>> problem, show us the *exact* query, the *exact* table definition, and >>> unfaked EXPLAIN ANALYZE output. >> I didn't realize that simplification was viewed as so sinister, but >> thanks, I'll remember that in the future. > > It's not sinister, it's counterproductive and wastes people's time. Unless "Ben" is an alias for someone high up with an unnamed rival database, seeking to distract us all... How do you find out the IP address of a yacht? ;-) -- Richard Huxton Archonet Ltd