Re: Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout - Mailing list pgsql-hackers

From Alex Hunsaker
Subject Re: Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout
Date
Msg-id 34d269d40804161621q8aa544dh6d10ab7a2c934d9e@mail.gmail.com
Whole thread Raw
In response to Re: Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: [PATCHES] Patch for Prevent pg_dump/pg_restore from being affected by statement_timeout  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
On Wed, Apr 16, 2008 at 4:54 PM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Joshua D. Drake escribió:
>
> > That is an interesting idea. Something like:
>  >
>  > pg_restore -E "SET STATEMENT_TIMEOUT=0; SET MAINTENANCE_WORK_MEM=1G" ?
>
>  We already have it -- it's called PGOPTIONS.
>

Ok but is not the purpose of the patch to turn off statement_timeout
by *default* in pg_restore/pg_dump?

Here is an updated patch for I posted above (with the command line
option --use-statement-timeout) for pg_dump and pg_restore.

(sorry If I hijacked your patch Josh :) )

Attachment

pgsql-hackers by date:

Previous
From: "Stephen Denne"
Date:
Subject: Re: count(*) performance improvement ideas
Next
From: Gregory Stark
Date:
Subject: Re: Lessons from commit fest