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

From Gregory Stark
Subject Re: Research/Implementation of Nested Loop Join optimization
Date
Msg-id 87myk5haxd.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Research/Implementation of Nested Loop Join optimization  ("Manoel Henrique" <mhenriquesgbd@gmail.com>)
Responses Re: Research/Implementation of Nested Loop Join optimization  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: Research/Implementation of Nested Loop Join optimization  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"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

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services!


pgsql-hackers by date:

Previous
From: Davy Durham
Date:
Subject: Re: Adding WHERE clause to pg_dump
Next
From: Gregory Stark
Date:
Subject: Re: Adding WHERE clause to pg_dump