pg_dump chews up all system memory

From: Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump chews up all system memory
Date: 2000-04-18 14:49:46
Message-ID: 38FC760A.D960F1A@cupid.suninternet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

To backup the postgres database on one of our
servers, we use pg_dump to dump the table to
a file. Now, we have a table that has around
300,000 records (iirc) but when pg_dump tries
to dump it, its size (in ps) grows to 270M
and the machine swaps like mad.

This is surely an error. I've temporarily fixed
it by adding another 128M swapfile (it was running
out completely and had to be rebooted) but I'd
really like to see pg_dump not use that much
memory in the first place.

Maybe it's fixed in newer versions?
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>

Browse pgsql-general by date

  From Date Subject
Next Message Nilesh A. Phadke 2000-04-18 15:34:59 Urgent ... Accessing the Index Structure
Previous Message Samy Elashmawy 2000-04-18 14:10:38 Re: Win32 Install