Port Bug Report: pg_dump eats memory when making backup

From: Unprivileged user <nobody>
To: pgsql-ports(at)postgreSQL(dot)org
Subject: Port Bug Report: pg_dump eats memory when making backup
Date: 1999-07-19 14:34:47
Message-ID: 199907191434.KAA89107@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Petter Reinholdtsen
Your email address : pere(at)td(dot)org(dot)uit(dot)no

Category : runtime: front-end
Severity : serious

Summary: pg_dump eats memory when making backup

System Configuration
--------------------
Operating System : Linux RedHat 5.2

PostgreSQL version : 6.5

Compiler used : gcc 2.7.2.3

Hardware:
---------
Linux picknose.student.uit.no 2.2.10 #2 SMP Tue Jun 15 16:41:59 METDST 1999 i686 unknown
Pentium II 350 MHz 256MB RAM

Versions of other tools:
------------------------

--------------------------------------------------------------------------

Problem Description:
--------------------
When running 'pg_dump -D -a -n <database>' to make a backup
of the data, the pg_dump program gets enormous. My database
makes a 104 MB backup file, and the pg_dump program had
~90MB memory usage. Larger databases gives a bigger memory
footprint, sometime to much for the machine.

--------------------------------------------------------------------------

Test Case:
----------

--------------------------------------------------------------------------

Solution:
---------

--------------------------------------------------------------------------

Browse pgsql-ports by date

  From Date Subject
Next Message Bruce Momjian 1999-07-19 18:17:12 Re: [COMMITTERS] 'pgsql/src/include/port linux.h'
Previous Message Unprivileged user 1999-07-19 08:30:03 Port Bug Report: IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1063936, permission=600