Postgres Pro
Downloads
Home   >   mailing lists

Re: hash join vs nested loop join - Mailing list pgsql-performance

From Huan Ruan
Subject Re: hash join vs nested loop join
Date
Msg-id CAD1stZsi_+AmGShfPRUOSwb2fYj35C87qsBKsTnxh5Wt9Vi8+A@mail.gmail.com
Whole thread Raw
In response to Re: hash join vs nested loop join  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
Tree view


On 13 December 2012 03:28, Jeff Janes <jeff.janes@gmail.com> wrote:

This looks like the same large-index over-penalty as discussed in the
recent thread "[PERFORM] Slow query: bitmap scan troubles".

Back-patching the log(npages) change is starting to look like a good idea.

Cheers,

Jeff

Thanks for the information Jeff. That does seem to be related. 

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: encouraging index-only scans
Next
From: Huan Ruan
Date:
Subject: Re: hash join vs nested loop join