R message Error: cannot allocate vector of size 3.7 Gb

I am trying to join two datasets of different sizes but hitting an issue with R message Error: cannot allocate vector of size 3.7 Gb. I tried increasing the memory and used a machine running 32GB of RAM but this hasn’t made any difference. The issue occurs with different types of join such fuzzy join and left, inner, and full. Any ideas, please?

Consider offloading the datasets to a database.

You will move from available memory constraint to available disk space constraint.

Memory is fast and expensive, disk is slow and cheap. Both have their uses...

1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.