We have tried running a query which would copy about 3 lakh records from workbench output (Amazon Redshift) to excel.
Error message as follows:
The system is running low on memory.
To prevent data corruption, the current operation has to be aborted.
Please increase the heap size with -Xmx parameter.
Ram of our windows (64 bit) instance is 4GB.
C and D drive have capacity of 100GB each.
I currently see, 512 MB is assigned to workbench.
We are using 64 bit JRE.
To what extent can the memory be assigned to workbench/ _JAVA_OPTIONS?
Can we increase it to 8 GB?
From manual, I can see, we can increase it to 1.5GB with 32 bit JRE.
But, No mention of size in case of 64 bit JRE.
Could you please clarify.