Out of Memory errors while running pg_dump

From: Erik Jones <erik(at)myemma(dot)com>
To: pgsql mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Out of Memory errors while running pg_dump
Date: 2008-02-04 17:00:27
Message-ID: 21DE4D90-93A9-479A-89D3-7CD5ECADDF6C@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, this past weekend I received a couple of Out of Memory errors
while running pg_dump for two different selects against the
catalogs, one with pg_get_viewdef() and the other with one of the
pg_index join pg_class left join pg_depend queries). Is it work_mem
I should be increasing with PGOPTIONS to avoid this?

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hiroshi Saito 2008-02-04 17:04:45 Re: msvcr80.dll and PostgreSQL 8.3 under Windows XP
Previous Message Selena Deckelmann 2008-02-04 16:58:28 Re: PostgreSQL Certification