Re: hash join vs nested loop join

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





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

This looks like the same large-index over-penalty as discussed in the
recent thread " 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. 


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux