On 3.7.2014 20:50, Tomas Vondra wrote: > Hi Stephen, > > On 3.7.2014 20:10, Stephen Frost wrote: >> Tomas, >> >> * Tomas Vondra (t...@fuzzy.cz) wrote: >>> However it's likely there are queries where this may not be the case, >>> i.e. where rebuilding the hash table is not worth it. Let me know if you >>> can construct such query (I wasn't). >> >> Thanks for working on this! I've been thinking on this for a while >> and this seems like it may be a good approach. Have you considered a >> bloom filter over the buckets..? Also, I'd suggest you check the >> archives from about this time last year for test cases that I was >> using which showed cases where hashing the larger table was a better >> choice- those same cases may also show regression here (or at least >> would be something good to test). > > Good idea, I'll look at the test cases - thanks.
I can't find the thread / test cases in the archives. I've found this thread in hackers: http://www.postgresql.org/message-id/caoezvif-r-ilf966weipk5by-khzvloqpwqurpak3p5fyw-...@mail.gmail.com Can you point me to the right one, please? regards Tomas -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
