Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 9AB369FB761 for ; Thu, 4 Oct 2007 17:35:54 -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 00733-03 for ; Thu, 4 Oct 2007 17:35:47 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.173]) by postgresql.org (Postfix) with ESMTP id D1AFA9FB75E for ; Thu, 4 Oct 2007 17:35:49 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so443180ugf for ; Thu, 04 Oct 2007 13:35:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=A6C4l5YVgio0WylojIWYOR/ju/ddeU3iDjhyqbpvTA4=; b=mkRGXap5TfSpkG/vOKnh1K5nqWFhiJtfaC+EpYYtrBTtZR4bdddTI7yFaFT1ZHilnCe1lJUxfasrQXP57h8SAe4XlRd21PTEHH3jwCALI+DXQxN6fZJOZqb/T3lgWBF1iEHOALHUY5L4dE2S0NNbC4+3HM1GBFHUJF7+AIckbxk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=c8FrYscznxEGBE9HHhY3e8Et+NjkybRevh1/MzdLuTUikFwpID4Bhi6uZYalUlWqVReH2hhSnEa679JbYE5LQjvAFKCR0BEEKJB42PykpjdYT6XTEeJ8Ned39+DLj2bOHMrKNl6ApJNF8YylY6R5jTm0a4mBqz9zaPwxigLXe+E= Received: by 10.66.221.17 with SMTP id t17mr2440132ugg.1191530146790; Thu, 04 Oct 2007 13:35:46 -0700 (PDT) Received: by 10.66.220.7 with HTTP; Thu, 4 Oct 2007 13:35:46 -0700 (PDT) Message-ID: Date: Thu, 4 Oct 2007 15:35:46 -0500 From: "Scott Marlowe" To: Ben Subject: Re: quickly getting the top N rows Cc: "Tom Lane" , pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <20071004141411.9509fe66.wmoran@collaborativefusion.com> <3785.1191523930@sss.pgh.pa.us> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/47 X-Sequence-Number: 27069 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.