Hash Join query performance

I have a query with several joins in big VDS (~10 rows per VDS). When I check the query planner, I’ve noticed that operations like hash_join consumed a lot of memory, and my query ran out of it.
I know that hashjoin operators consume tons of memory, but, is there any way to make it consume less memory during join operations?

1 Like