Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 3FD262E37AB for ; Tue, 18 Dec 2007 17:21:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 44079-02 for ; Tue, 18 Dec 2007 17:21:46 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 431EE2E371C for ; Tue, 18 Dec 2007 17:21:49 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id lBILLl13005104; Tue, 18 Dec 2007 16:21:47 -0500 (EST) To: Deron cc: pgsql-admin@postgresql.org Subject: Re: Set maintenance work mem for pg_restore In-reply-to: References: Comments: In-reply-to Deron message dated "Tue, 18 Dec 2007 12:30:12 -0800" Date: Tue, 18 Dec 2007 16:21:47 -0500 Message-ID: <5103.1198012907@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/172 X-Sequence-Number: 27689 Deron writes: > Does anyone know if there is a way to only "temporarily" set this setting? Aside from the specific answers already given, the general answer is to read http://www.postgresql.org/docs/8.2/static/config-setting.html which enumerates all (most?) of the many ways you can set configuration parameters. regards, tom lane