How can we help you today?
PostgreSQL @export query - out of memory
3 CommentsSorted by Oldest First
Hans Bergsten
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: PostgreSQL @export query - out of memory
Re: PostgreSQL @export query - out of memory
Hi Doug,
As far as I know, the PostgreSQL driver does not have any "buffer all rows" setting so the @export command should only read one row at a time into memory. Does the query include BLOB/CLOB columns that may hold very large values?
Please enable debugging for DbVisualizer in Tools->Debug Window and mail or post the output from running the @export command.
Best Regards,
Hans
Roger Bjärevall
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: PostgreSQL @export query - out of memory
Re: PostgreSQL @export query - out of memory
Doug,
The PostgreSQL driver buffer all rows in the result set before handing it over to DbVisualizer. To solve this add the following driver property in Connection Properties / Driver Properties by adding a new row (parameter = value):
java.sql.statement.setFetchSize = 10
Click Apply and re-connect. In the SQL Commander you are running the @export script you must make sure it is not in Auto Commit mode, as the driver in auto commit mode still will buffer the result set.
I hope this helps.
Regards
Roger
[This reply is migrated from our old forums. The original author name has been removed]
Re: PostgreSQL @export query - out of memory
Re: PostgreSQL @export query - out of memory
That setting solved the problem. Thanks!
anonymous