why pg_dump eats so much memory?
I just noticed that when I run pg_dump to backup my databases it will use
enormous amounts of memory, eating over 70 MB and causing the system to
trash. Then after a while it'll shrink to about 30MB, then grow again, and
repeat the cycle a couple times. The database has 3 tables with araound
350,000 rows, and one table with 1,300,000 rows.
I would like to know the causes of that behaviour, and, hopefully, how I can
fix it. I'm running 7.0.2 on freebsd 4.1.
Thanks!
=?iso-8859-1?Q?Crist=F3v=E3o_Dalla_Costa?= <cdallacosta@bigfoot.com> writes:
I just noticed that when I run pg_dump to backup my databases it will use
enormous amounts of memory,
I would like to know the causes of that behaviour, and, hopefully, how I can
fix it. I'm running 7.0.2 on freebsd 4.1.
Don't use -d or -D options.
regards, tom lane