Re: hash join vs nested loop join

From: Huan Ruan <huan(dot)ruan(dot)it(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Huan Ruan <leohuanruan(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: hash join vs nested loop join
Date: 2012-12-13 00:56:21
Message-ID: CAD1stZsi_+AmGShfPRUOSwb2fYj35C87qsBKsTnxh5Wt9Vi8+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 13 December 2012 03:28, Jeff Janes <jeff(dot)janes(at)gmail(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Huan Ruan 2012-12-13 01:10:24 Re: hash join vs nested loop join
Previous Message Kevin Grittner 2012-12-12 23:47:32 Re: hash join vs nested loop join