From: Gerd W. <ger...@t-...> - 2019-03-19 20:26:35
|
Sorry, I can't reproduce your problem. My first guess is you are using a 32 bit JRE/JDK. Gerd Am 13.03.19 um 22:00 schrieb Christopher Dick (Chris): > 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: > > 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><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. > > __________________________________________________________________________________________________________________ > > > > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |