From: Richard Huxton <dev@archonet.com>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Ben <bench@silentmedia.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: quickly getting the top N rows
Date: Thu, 04 Oct 2007 22:01:45 +0100
Message-ID: <470554B9.6070506@archonet.com> (raw)
In-Reply-To: <dcc563d10710041335u3891221dw8f17c72536ea427d@mail.gmail.com>
References: <Pine.LNX.4.64.0710041053590.30864@localhost.localdomain>
<20071004141411.9509fe66.wmoran@collaborativefusion.com>
<Pine.LNX.4.64.0710041126010.30864@localhost.localdomain>
<3785.1191523930@sss.pgh.pa.us>
<Pine.LNX.4.64.0710041229080.30864@localhost.localdomain>
<dcc563d10710041335u3891221dw8f17c72536ea427d@mail.gmail.com>
Scott Marlowe wrote:
> On 10/4/07, Ben <bench@silentmedia.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dev@archonet.com, scott.marlowe@gmail.com, bench@silentmedia.com, tgl@sss.pgh.pa.us
Subject: Re: quickly getting the top N rows
In-Reply-To: <470554B9.6070506@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox