Details, Fiction and Join fast
Hash joins are best if none of the associated relations are smaller, but the hash desk for the smaller desk matches in work_mem. It is because usually PostgreSQL would Establish the hash in various batches and keep them in momentary disk data files, which hurts functionality. In these types of instances the optimizer commonly chooses a different jo