Re: Memory usage and pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Memory usage and pg_dump
Date: 2001-05-21 18:55:25
Message-ID: 4751.990471325@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> writes:
> Anyway, any idea why the behaviour is so different, and how I might tinker
> with the schema?

-D does a SELECT not a COPY, so pg_dump has to buffer the whole contents
of a table when you do that. Consider increasing your kernel limit on
process size.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message dave go 2001-05-21 19:01:40 Select statement
Previous Message Alex Hochberger 2001-05-21 18:42:10 Tweaking on an OpenBSD Machine