Re: Set maintenance work mem for pg_restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Deron <fecastle(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Set maintenance work mem for pg_restore
Date: 2007-12-18 21:21:47
Message-ID: 5103.1198012907@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Deron <fecastle(at)gmail(dot)com> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message olivier.boissard@cerene.fr 2007-12-18 22:21:15 How to uses self query plan
Previous Message Scott Marlowe 2007-12-18 20:54:07 Re: Set maintenance work mem for pg_restore