|
From: Christopher D. (Chris) <Chr...@mp...> - 2019-03-13 21:15:37
|
Hi, I have an issue where users are unable to adjust to .bat file for memory over 1gb without the program collapsing ie cannot set this parameter -Xmx1024m to 2, 4 or 8gb. We deal with large and growing datasets i.e. over 1 million rows for a lot of tables and it is annoying to split up the query into parts then concatenate the result if we do not do this then we get the below error msg: [cid:image005.png@01D4DA4C.B4361580] Is this a known issue that can be resolved, we connect to a Postgres database and hence driver to run the queries and currently running version 3.8.1. Please let me know if you require any further information to progress things. Cheers, Chris Christopher Dick | Senior Data Analyst Fisheries Science and Information | Fisheries New Zealand Ministry for Primary Industries - Manatū Ahu Matua | Charles Fergusson Tower 34-38 Bowen Street | PO Box 2526 | Wellington 6011 | New Zealand Telephone: 64-4-894 3490 | Facsimile: 64-4-894 0228 | Mobile: 027-383 8935 | Web: www.mpi.govt.nz Follow MPI [Twitter icon]<https://twitter.com/MPI_NZ>[cid:ima...@01...BE9300]<http://www.facebook.com/MPIgovtnz>[LI icon]<https://www.linkedin.com/company/new-zealand-ministry-for-primary-industries>[YouTube icon]<https://www.youtube.com/user/MinPrimaryIndustries> _____________________________________________________________________________________ This email message and any attachment(s) is intended solely for the addressee(s) named above. The information it contains may be classified and may be legally privileged. Unauthorised use of the message, or the information it contains, may be unlawful. If you have received this message by mistake please call the sender immediately on 64 4 8940100 or notify us by return email and erase the original message and attachments. Thank you. The Ministry for Primary Industries accepts no responsibility for changes made to this email or to any attachments after transmission from the office. _____________________________________________________________________________________ |
