Which processes really require occupying and 
    allocating bigger blocks of RAM?

It's not uncommon to work with e.g. 50GB+ databases these days.

They don't always need to be in RAM, particularly with modern SSD performance, but if you're using a laptop for your day job and you work with largeish data...