Way to not use a transaction?

[mmetzger]

Hi -

We're transferring a large amount of data but seeing the server eat a huge amount of memory during the transfer. Looking in the profiler, it appears to issue a transaction at the beginning of the transfer. Is there an easy way to disable this and simply execute the command directly?

Thanks!

[Moderator]

Are you transferring data into the Postgres DB? If that's the case, are you using connection string parameter BULK_METHOD=COPY?

[mmetzger]

Yes, it's transferring data into postgres. I had tried using the COPY option, but unfortunately postgres does not appear to support the use of BYTEA fields in COPY options (even COPY BINARY) as all my tests came out blank.

[Moderator]

Could you send us tables schema and any additional information to help us reproduce the issue with large memory utilization?

We are working on bytea and COPY issue.

Thank you