Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id E43509FA0EF for ; Wed, 3 Jan 2007 14:26:52 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 00533-06 for ; Wed, 3 Jan 2007 14:26:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id AE2999F931E for ; Wed, 3 Jan 2007 14:26:41 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l03IQdd0016138; Wed, 3 Jan 2007 13:26:39 -0500 (EST) To: Erik Jones cc: Guillaume Smet , pgsql-performance@postgresql.org Subject: Re: More 8.2 client issues (Was: [Slow dump?) In-reply-to: <459BEEB8.5050405@myemma.com> References: <459AD5A8.7030102@myemma.com> <22512.1167779361@sss.pgh.pa.us> <459BD61C.3030202@myemma.com> <11617.1167841479@sss.pgh.pa.us> <459BDC98.8030008@myemma.com> <1d4e0c10701030850h78f19e74hfa7c25c01ded9a61@mail.gmail.com> <459BE4BB.4070601@myemma.com> <13359.1167844898@sss.pgh.pa.us> <459BEEB8.5050405@myemma.com> Comments: In-reply-to Erik Jones message dated "Wed, 03 Jan 2007 11:58:16 -0600" Date: Wed, 03 Jan 2007 13:26:39 -0500 Message-ID: <16137.1167848799@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/43 X-Sequence-Number: 22644 Erik Jones writes: > That's a good idea, but first I'll still need to run it by my sysadmin > wrt space -- our dump files are around 22GB when we can let them finish > these days. Given that we're now speculating about regex problems, you could do a test run of "pg_dump -s" with logging enabled; that shouldn't take an unreasonable amount of time or space. regards, tom lane