X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 757A23A5C6D for ; Wed, 26 Jan 2005 16:19:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37887-09 for ; Wed, 26 Jan 2005 16:19:41 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 65F643A5C48 for ; Wed, 26 Jan 2005 16:19:40 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0QGJZjx015490; Wed, 26 Jan 2005 11:19:36 -0500 (EST) To: Marty Scholes Cc: pgsql-admin@postgresql.org Subject: Re: 7.4.6 pg_dump failed In-reply-to: <41F7B44F.7030706@outputservices.com> References: <41F7B44F.7030706@outputservices.com> Comments: In-reply-to Marty Scholes message dated "Wed, 26 Jan 2005 08:16:31 -0700" Date: Wed, 26 Jan 2005 11:19:35 -0500 Message-ID: <15489.1106756375@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/270 X-Sequence-Number: 16129 Marty Scholes writes: > A pg_dump of one table ran for 28:53:29.50 and produced a 30 GB dump > before it aborted with: > pg_dump: dumpClasses(): SQL command failed > pg_dump: Error message from server: out of memory for query result > pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor Even though it says "from server", this is actually an out-of-memory problem inside pg_dump, or more specifically inside libpq. > The table contains a text field that could contain several hundred MB of > data, although always less than 2GB. "Could contain"? What's the actual maximum field width, and how often do very wide values occur? I don't recall the exact space allocation algorithms inside libpq, but I'm wondering if it could choke on such a wide row. You might have better luck if you didn't use -d. regards, tom lane