If your problem is the Ecto preload, and not an huge dataset in one variable, then you may want to see if the official docs on preload queries can help:
Sourced from this Stackoverflow question:
Another resource I found on preload is this talk:
In the past Ecto preload had issues with memory as per this issue:
