Out of Memory errors while running pg_dump - Mailing list pgsql-general

From Erik Jones
Subject Out of Memory errors while running pg_dump
Date
Msg-id 21DE4D90-93A9-479A-89D3-7CD5ECADDF6C@myemma.com
Whole thread Raw
Responses Re: Out of Memory errors while running pg_dump
List 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@myemma.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




pgsql-general by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: msvcr80.dll and PostgreSQL 8.3 under Windows XP
Next
From: "Hiroshi Saito"
Date:
Subject: Re: msvcr80.dll and PostgreSQL 8.3 under Windows XP