You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by Brian McCallister <mc...@forthillcompany.com> on 2003/04/16 17:02:17 UTC

datadump and large databases

I posed this question on the users list, but it really belongs here.

Are there any significant differences between the datadump task in 3.0 
and 3.1? It presently fails with memory problems on large databases - 
while I realize it was never really meant for large database work, it 
sure as heck could be convenient tool for database migration if it did 
work nicely =)

The exact situation I am hitting is:

Using PostgreSQL 7.3.2, the org.postgresql.Driver current release 
version, about 600 megs of data on an uncompressed sql dump and 
allocating a 1.5 GB heap to ant I out of memory error part way through. 
This is on Torque 3.0 release

I haven't had a chance to look at the code, just wanted to ask if by 
chance 3.1 uses streamed data instead of apparently keeping a fairly 
large in-memory model of the whole thing =)

-Brian McCallister