Re: Research/Implementation of Nested Loop Join optimization - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Research/Implementation of Nested Loop Join optimization
Date
Msg-id 1217028919.16378.142.camel@jd-laptop
Whole thread Raw
In response to Re: Research/Implementation of Nested Loop Join optimization  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: Research/Implementation of Nested Loop Join optimization  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Fri, 2008-07-25 at 19:31 -0400, Jonah H. Harris wrote:
> On Fri, Jul 25, 2008 at 6:10 PM, Gregory Stark <stark@enterprisedb.com> wrote:
> > "Manoel Henrique" <mhenriquesgbd@gmail.com> writes:
> >
> >> Yes, I'm relying on the assumption that backwards scan has the same cost as
> >> forward scan, why shouldn't it?
> >
> > Because hard drives only spin one direction
> 
> :)

What if you are below the equator?

> -- 
> Jonah H. Harris, Senior DBA
> myYearbook.com
> 
-- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate





pgsql-hackers by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: Research/Implementation of Nested Loop Join optimization
Next
From: Alvaro Herrera
Date:
Subject: Re: Research/Implementation of Nested Loop Join optimization