Re: quickly getting the top N rows

From: Richard Huxton <dev(at)archonet(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Ben <bench(at)silentmedia(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: quickly getting the top N rows
Date: 2007-10-04 21:01:45
Message-ID: 470554B9.6070506@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Scott Marlowe wrote:
> On 10/4/07, Ben <bench(at)silentmedia(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2007-10-04 21:04:53 Re: quickly getting the top N rows
Previous Message Scott Marlowe 2007-10-04 20:35:46 Re: quickly getting the top N rows