The PostgreSQL driver buffer all rows in the result set before handing it over to DbVisualizer. This may lead to out of memory situations. Check the Set query fetch size article how to prevent this.
In the SQL Commander, if you are running a @export script you must also make sure that Auto Commit is off, as the driver still buffers the result set in auto commit mode.