Hello
Wanted to know How much Memory required to generate report from 2 Billion records?
Have 2 billions records but not able to complete MDX query in few minutes. Any performance tuning can do in it.
I am using Postgres DB and have work_mem of 12MB.