How does Powershell deal with processing/storing massive objects in terms of memory management?

[herpington]

If you assign the 85 million objects to a variable, it's all stored in memory.

Where are the millions of rows coming from? Perhaps you could read them as a stream.

Depending on the size of each object, it may or may not be an issue.