The best Side of Join fast
Hash joins are very best if none of the concerned relations are smaller, nevertheless the hash table for the smaller sized table suits in work_mem. This is due to otherwise PostgreSQL would build the hash in a number of batches and store them in short term disk data files, which hurts efficiency. In