Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Research/Implementation of Nested Loop Join optimization
Date
Msg-id 8815.1217050707@sss.pgh.pa.us
Whole thread Raw
In response to Re: Research/Implementation of Nested Loop Join optimization  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-hackers
Tree view 
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> Tom Lane wrote:
>> A backwards scan will get no such overlapping and thus be up to 2X
>> slower, unless the kernel is smart enough to do read-ahead for
>> descending-order read requests.  Which seems not too probable. 

> Linux's old adaptive readahead patches claimed to[1]:

I didn't say that there were *no* platforms that could do it.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Research/Implementation of Nested Loop Join optimization
Next
From: Markus Wanner
Date:
Subject: Re: Transaction-controlled robustness for replication