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
>
|